MySQL server access restored.

morteza3245

• July 02, 2015 05:55

Hello after i did increase using below command: echo 524288 > /proc/sys/net/ipv4/ip_conntrack_max i received below error in email:
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?

• 

  24x7server

  • July 03, 2015 12:45

  Hello, I can see you are getting Too many connections error so you need to increase your connection limit value in your my.cnf file to resolve this issues.

  0
• 

  morteza3245

  • July 03, 2015 13:44

  if i do not increase connection, server will see down time? and which one i should increase exactly? Thanks.

  0
• 

  DonaldBennett

  • July 04, 2015 08:52

  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.

  0
• 

  cPanelMichael

  • July 15, 2015 17:17

  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.

  0

Please sign in to leave a comment.