连接mysql，结果出错：
|
1
|
ERROR 1040 (HY000): Too many connections |
去修改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=1lower_case_table_names=0lower_case_table_names=1datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=100max_user_connections=100# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-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/Systemduser=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 -AWelcome 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 AtomicorpCopyright (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 respectiveowners.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=100max_user_connections=100 |
当然可以根据自己需要，设置更大的值。
然后再重启mysqld：
|
1
|
service mysqld restart |
即可正常连接mysql。