【引用】mysql ERROR 1040 (08004): Too many connections
【引用】mysql ERROR 1040 (08004): Too many connections
2011年10月26日
重要提醒：系统检测到您的帐号可能存在被盗风险，请尽快查看风险提示，并立即修改密码。 | 关闭
网易博客安全提醒：系统检测到您当前密码的安全性较低，为了您的账号安全，建议您适时修改密码 立即修改 | 关闭
[root@cdel-mail1 ~]# mysql -h219.168.28.68 -uuseril -p
Enter password:
ERROR 1040 (08004): Too many connections
直接修改mysql
[/b] mysql> show variables;
mysql> set GLOBAL max_connections=1000;
[b]修改：/etc/my.cnf
[root@cdel-mail1 ~]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
set-variable=max_connections=1000
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
~
------------------
陈龙
QQ:84047848
MSN:dragonchen82@hotmail.com
