MySQL server access restored.

morteza3245

Well-Known Member
Sep 16, 2013
154
1
68
cPanel Access Level
Root Administrator
Hello
after i did increase using below command:
echo 524288 > /proc/sys/net/ipv4/ip_conntrack_max

i received below error in email:

Code:
MySQL server access restored.
   

The system was unable to authenticate to the local MySQL server on “localhost”.

The connection driver reported the following error: Too many connections

The system automatically reset the MySQL root password in order to restore normal operations.

The system restored the password to the password in “/root/.my.cnf”.
what is it?

how i can resolve it?
 

DonaldBennett

Registered
PartnerNOC
Jul 4, 2015
2
0
1
Tampa, FL
cPanel Access Level
DataCenter Provider
Hello,

You can increase the server max_connections limit in /etc/my.cnf

So, SSH Into the server And Run The Following Steps:

1. nano /etc/my.cnf
2. On a new line you can type max_connections=250 (Or Whatever your limit maybe 250 is pretty Standard)
3. Save The File holding Ctrl+O And it will Save The File.
4. Restart MySQL Using: service mysql restart
5. Check Connection limit: echo "show variables like 'max_connections';" | mysql

Try it out and let me know. :)

Thank You.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
Hello :)

You can review your MySQL error log (/var/lib/mysql/$hostname.err) to see the specific error message when MySQL fails to load. This will help you determine which entries to change in your /etc/my.cnf file.

Thank you.