ERROR 2002 (HY000): Can ' t connect to local MySQL solution

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.

This article is from the "one dish can no longer dish of the Little rookie" blog, please be sure to keep this source http://liliming.blog.51cto.com/10925034/1825535

ERROR 2002 (HY000): Can ' t connect to local MySQL solution