Troubleshoot MySQL error can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '

Start MySQL Error:

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

1. Check the/ETC/RC.D/INIT.D/MYSQLD status first to see if M y S Q L has been started.
Also see if it is a permission issue.

2. Determine if your mysql.sock is in that position,
Mysql-u your MySQL user name-p-s/var/lib/mysql/mysql.sock

3, try: Service mysqld start

4, if it is a permission problem, change the permissions first #chown-R mysql:mysql/var/lib/mysql

[[email protected] ~]#/etc/init.d/mysqld start
Start MySQL: [OK]
[Email protected] ~]# mysql-uroot-p



ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)
The reason for this is that the/var/lib/mysql access rights issue.

Shell> Chown-r Mysql:mysql/var/lib/mysql

Then start the server

Shell>/etc/init.d/mysql Start

After the server starts normally, look/var/lib/mysql automatically generate Mysql.sock files.

But my problem is still unresolved.

The problem is finally solved:
Method: Modify/etc/my.conf:
[Mysqld]
Datadir=/usr/local/mysql/data
Socket=/var/lib/mysql/mysql.sock

[Mysql.server]
User=mysql
Basedir=/usr/local/mysql

If There is not currently a section called [Client], add one at the bottom of the file and copy the socket= line under the [MYSQLD] section such as:

[Client]
Socket=/var/lib/mysql/mysql.sock


Found still so, run/etc/init.d/mysql start error: Starting mysqlcouldn ' t find MySQL manager or server
Is mysqld service not started, run/usr/local/mysql/bin/mysqld_safe &

Problem solving.

Troubleshoot MySQL error can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock '