mysql ERROR 1040 (08004): Too many connections

故障现象:

#mysql -uuser -ppasswd

ERROR 1040 (08004): Too many connections

解决办法1:

#mysql -uroot -ppasswd

mysql> show variables;

| max_connections                 | 100   

mysql> set GLOBAL max_connections=1500;

解决办法2:

#vi /etc/my.cnf

[mysqld]

………………

set-variable=max_connections=1500

[mysqld_safe]


原文地址:https://www.cnblogs.com/myiaas/p/4161310.html