Fault Description:
Start MySQL Error:
ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)
1. Check MySQL boot status first
#/etc/rc.d/init.d/mysqld status
2.mysql.sock location lookup and verification?
# Find/-name Mysql.sock
/data/mydata/mysql.sock
Verify that the directory is correct
#mysql-U root-p-s/data/mydata/mysql.sock
Note:-s parameter socket file validation
3. Verify that the Mysql.sock file permissions and the user are correct?
If this is a permission issue, change the permissions first
#chown-R Mysql:mysql/data/mydata/mysql.sock
[[email protected] ~]#/etc/init.d/mysqld start
Start MySQL: [OK]
4. Permanent resolution
Modify/ETC/MY.CNF
Add the following to/etc/my.conf:
[Client]
Socket =/data/mydata/mysql.sock
[Mysqld]
Socket =/data/mydata/mysql.sock
Can ' t connect to local MySQL server through socket solution