【背景】
折腾:
【已解决】OpenFire无法解析domain:org.jivesoftware.openfire.XMPPServer – Unable to determine local hostname
期间,去连接mysql,结果出错:
ERROR 1040 (HY000): Too many connections
如图:
【解决过程】
1.搜:
mysql ERROR 1040 (HY000): Too many connections
找了一堆没用。
mySQL Error 1040: Too Many Connection – Stack Overflow
MySQL :: MySQL 5.5 Reference Manual :: B.5.2.7 Too many connections
2.参考:
Help!!!! 1040 – Too many connections | Web Hosting Talk
去修改mysql的配置文件,然后添加:
root@bogon:logs# vi /etc/my.cnf [mysqld] lower_case_table_names=1 lower_case_table_names=0 lower_case_table_names=1 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock max_connections=100 max_user_connections=100 # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used (fedora >= 15). # If you need to run mysqld under a different user or group, # customize your systemd unit file for mysqld according to the # instructions in http://fedoraproject.org/wiki/Systemd user=mysql # Semisynchronous Replication # http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html # uncomment next line on MASTER ;plugin-load=rpl_semi_sync_master=semisync_master.so # uncomment next line on SLAVE ;plugin-load=rpl_semi_sync_slave=semisync_slave.so # Others options for Semisynchronous Replication ;rpl_semi_sync_master_enabled=1 ;rpl_semi_sync_master_timeout=10 ;rpl_semi_sync_slave_enabled=1 # http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html ;performance_schema [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
然后重启mysqld:
oot@bogon:logs# service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ] root@bogon:logs#
然后重新连接试试,就可以了:
root@bogon:logs# mysql -u root -p openfire_schoolike Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 440 Server version: 5.5.44-cll-lve MySQL Community Server (GPL) by Atomicorp Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
【总结】
当连接mysql时,出现:
ERROR 1040 (HY000): Too many connections
的错误时:
去增加mysql的最大连接数即可:
修改mysql的配置文件:
/etc/my.cnf
在[mysqld]字段中增加配置:
max_connections=100 max_user_connections=100
当然可以根据自己需要,设置更大的值。
然后再重启mysqld:
service mysqld restart
即可正常连接mysql。
转载请注明:在路上 » 【已解决】mysql连接出错:ERROR 1040 (HY000): Too many connections