Solution for: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Posted by:   ()

Date: June 07, 2008 02:00AM

 

Hi everybody, 

I have got the same problem, but I have solved it by doing the following steps: 

First: Make sure that the owner of /var/lib/mysql and its files and subdirectories is mysql user of mysql group 

to do that run the following command: 

chown mysql.mysql -R /var/lib/mysql/* 

Second: change write permissions to rwxr-xr-x (755) for mysql directory, and all its files and subdirectories, by running the following command: 

chmod 755 -R /var/lib/mysql/* 

now start mysql service by running the following command (Red Hat and may fedora): 

service mysql start 

the error message should disappear and should output: 

Starting MySQL. [ OK ]