Tuesday, July 5, 2011

MYSQL : mysqld server - SOCKET ERROR

MYSQL : mysqld server - SOCKET ERROR

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'

Following are the scenarios for getting socket error - 

1. Check whether mysqld server is running or not, using the below command
ps -ef | grep mysql

If mysqld is running, then check the socket path in the configuration file ( ie.. my.cnf )and give the correct path when connecting.

2. Check the file permission of that socket file. If the file doesn’t have mysql permission, just change permission to mysql using the below command.

chown mysql:mysql /usr/local/mysql/mysql.sock

3. If the socket file is missing then you have to restart your mysqld server. Its automatically create new socket...


No comments: