Can't connect to local MySQL server through socket (From time to time)

Question

I have a LAMP stack setup. Occasionally, I get the following error message when I open some page from the browser:

Error creating the connection!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I think the server was configured correctly. The problem happens about every two months. Every time when I reboot the Linux server, or restart mysql, the problem was gone. I want to fix this problem permanently. Can anyone give me some idea?

Much appreciated.

EDIT

The problem occurs again and I checked the mysqld.sock file, it was not there. Do you have any idea how to fix the problem? – Ryan Jul 23 at 16:24

Answer 1

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with

socket=/var/run/mysqld/mysqld.sock

modified

#bind-address = 127.0.0.1

to

bind-address = localhost

you can check if mysql is running with the following command:

mysqladmin -u root -p status

try changing your permission to mysql folder. If you are working locally, you can try:

sudo chmod -R 755 /var/run/mysqld/

And then restart the mysql.

Good luck.

Answer 2

Could it be the log file getting too large and rebooting flushes it. See this in docs on server maintenance and logfiles. Also see discussion at digital ocean. Appears to be confirmed by discussion at serverfault