mysql5.6无法连接_Mysql5.6设置max_connections失败解决办法

my.cnf 无法修改连接数，报错信息：

[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 15000)

[Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000)

[Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 1520)

修改/etc/security/limits.conf

添加：

mysql hard nofile 65535

mysql soft nofile 65535

vi /usr/lib/systemd/system/mysqld.service.d/limits.conf      #创建并配置配置文件

[Service]

LimitNOFILE=10000

# 重新加载配置文件

systemctl daemon-reload

#重启mysqld服务，使配置生效。

systemctl restart mysqld.service