What does this MySQL error mean?

 

There are many reasons why you could get a MySQL error. Below we will discuss about the most common error that can happen, when hosting a forum or a mass visited site. You may see an error such as the one below:

Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) [2002]

If so, this basically means that your application has run out of concurrent connections it can use for the MySQL server. There are a couple of things we can do to fix this.

Restart your VPS (Simplest):

Restarting your VPS will close all the open MySQL concurrent connections, and free up slots in the table. Once your VPS is restarted, this error message will go away.

All the information can be found in the Welcome email on how to do this.

Editing your /etc/my.cnf file (Advanced):

If you are familiar with Linux, you may edit the my.cnf file which is going to be located in the /etc/ folder. When editing it, you will be able to set the concurrent connection limit such as we have outlined below. Simply making it larger than the current value, and then save and restart your MySQL.

max_connections = 500

  • 0 Els usuaris han Trobat Això Útil
Ha estat útil la resposta?

Articles Relacionats

How to change a cPanel password through WHM?

  From time to time, account holders lose their passwords, and need to rest them. Using...

How to modify an account's disk quota in WHM?

  You can use Quota Modification directly from the WHM to affect on how much disk space...

Can I modify the suspended account page?

  Feel free to modify the suspended account page it to your liking. Follow these steps to...

How do I list the suspended accounts in WHM?

  If you want to list the suspended accounts, please do the following: Login to your WHM...

How to get info on bandwidth usage from WHM?

  This process is simple. Simply follow the below outlined instructions: Log to the WHM...

Powered by WHMCompleteSolution