Error prompts such as:
The code is as follows |
Copy Code |
$mysql-uroot ERROR 1040 (00000): Too Many connections |
Because I use the MYSQL5 server is Win2000 This method is good to solve, find me MySQL installation directory such as C:windowsmysql found My.ini configuration file.
Ctrl+f search Max_connections, because of your MySQL installation directory in the My.ini set in the number of concurrent connections is too small or the system busy caused the number of connections is full, here do not know what time is designed to 2, I change it to
The code is as follows |
Copy Code |
max_connections = 1000 max_user_connections=300 |
The final reboot of the database is OK.
The above is said to have the MySQL server permissions, if no friends can contact space business Oh.
Original site reproduced must be noted from the http://www.111cn.nethttp://www.111cn.net/database/database.html