error connection

It’s can be as when a client tries to connect MySQL server the request can be rejected and receive an error “too many connections “ to server has been reached. So you will have to increase max_connections request in my.cnf file in order to resolve this issue.

Login to your MySQL server and run this command to check Max_connection

show variables like “max_connections”;

As you can see the default connection is 151 So you have to increase it size.

To change the value of Max_connection can be done by set command

SET GLOBAL max_connections =512;

 

Now verify

It is temporary solution as when MySQL service will be restarted it will again set to default value 151. To make it permanent, change it in /etc/my.cnf file.

Now restart the MySQL service to take an effect.

You’re done

Sponsored

LEAVE A REPLY

Please enter your comment!
Please enter your name here