【背景】
折腾:
【已解决】OpenFire无法解析domain:org.jivesoftware.openfire.XMPPServer – Unable to determine local hostname
期间,去连接mysql,结果出错:
1 | 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的配置文件,然后添加:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 | 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 # 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 ;performance_schema [mysqld_safe] log-error= /var/log/mysqld .log pid- file = /var/run/mysqld/mysqld .pid |
然后重启mysqld:
1 2 3 4 | oot@bogon:logs # service mysqld restart Stopping mysqld: [ OK ] Starting mysqld: [ OK ] root@bogon:logs # |
然后重新连接试试,就可以了:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | 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]字段中增加配置:
1 2 | max_connections=100 max_user_connections=100 |
当然可以根据自己需要,设置更大的值。
然后再重启mysqld:
1 | service mysqld restart |
即可正常连接mysql。
转载请注明:在路上 » 【已解决】mysql连接出错:ERROR 1040 (HY000): Too many connections