Tuesday, October 22, 2013

mySQL Error 1040: Too Many Connection

If you get a Too many connections error when you try to connect to the mysql server, this means that all available connections are in use by other users.The number of connections permitted is controlled by the max_connections system variable when MySQL is used with the Apache Web server  you should set a larger value for this variable to do so follow the steps below.

SSH server as root user

goto my.cnf

etc/my.cnf

if not able to find the file use the command below.

find / -name | grep my.cnf

vi my.cnf

Find the line increase max_user_connection  and make changes as per your need.

increase max_user_connection=500

increase value 500 is the no of connections allowed currently.

No comments:

Post a Comment

Do Write about the Blog and Welcome to the world where open source is every thing :-)