代码改变世界

mysql ERROR 1040 (08004): Too many connections

2014-06-25 16:07  陈尚华  阅读(762)  评论(0编辑  收藏  举报

故障现象:

#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]