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: 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
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) [2002]
- 0 användare blev hjälpta av detta svar
Relaterade artiklar
Powered by WHMCompleteSolution
