How to solve the too many connections error in mysql

This article mainly explains the "mysql too many connections error tips how to solve", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "mysql too many connections error tips how to solve" it!

Error prompts such as:

$mysql-uroot

ERROR 1040 (00000): Too many connections

Because I am using the mysql5 server is win2000 this method is easy to solve, find my mysql installation directory such as C:windowsmysql found the my.ini configuration file.

Ctrl+f searched for max_connections and found the reason. Because the number of concurrent connections set in my.ini under your mysql installation directory is too small or the system is busy, the number of connections is full. I don't know when it was designed to be 2. I'll change it to

Max_connections = 1000

Max_user_connections=300

Finally, restart the database.

Thank you for your reading, the above is the "mysql too many connections error prompt how to solve" the content, after the study of this article, I believe you have a deeper understanding of mysql too many connections error prompt how to solve this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!