Can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2)

[Email protected] bin]#./mysql-p
Enter Password:
ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2)
[Email protected] bin]#

My MySQL normally starts, but I want to go into the Mysql> interface and run the./mysql-p prompt for the above error.


Ask Master This is what reason, how should solve????
Thank you!!!!

Best Answer (respondents: ribut9225)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 MySQL 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

[Root@localhost ~]#/etc/init.d/mysqld start
Start MySQL: [OK]
[Root@localhost ~]# mysql-u root-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 the MYSQLD service is not restarted, run/usr/local/mysql/bin/mysqld_safe &

Problem solving.

When you perform PHP, this is like this:

Warning:mysql Connection Failed:can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (111) in/home/http D/html/show.php on line 9

Please/tmp/mysql.sock link to the/var/lib/mysql catalogue:

linux# ln-s/var/lib/mysql/mysql.sock/tmp/mysql.sock

Can ' t connect to local MySQL server through socket '/tmp/mysql.sock ' (2)