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.
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 :-)