解决Linux MySQL报错ERROR 2002

---------------------------------1---------------------------------在Linux安装MySQL有时候会出现[mysql]ERROR 2002 （HY000）: Can"t connect to local MySQL server through socket "/var/lib/mysql/mysql.sock" （2）这样的错误，具体解决办法如下：

[root@www ~]# rm -rf /var/lib/mysql/*
[root@www ~]# rm /var/lock/subsys/mysqld
rm: remove regular empty file `/var/lock/subsys/mysqld"？ y
[root@www ~]# killall mysqld
[root@www ~]# service mysqld start
[root@www ~]# /etc/rc.d/init.d/mysqld status
mysqld （pid 5457） is running...---------------------------------2---------------------------------[root@r710-1 /]# mysql -u root
ERROR 2002 （HY000）: Can"t connect to local MySQL server through socket "/tmp/mysql.sock" （2）
[root@r710-1 /]# vi /etc/my.cnf
##########添加如下内容：
[client]
socket=/var/lib/mysql/mysql.sock
##########保存退出后，
##########重启mysql
[root@r710-1 /]# service mysqld restart
Shutting down MySQL. [ OK ]
Starting MySQL. [ OK ][root@r710-1 /]# mysql -u root -p
Enter password:
ERROR 1045 （28000）: Access denied for user "root"@"localhost" （using password: YES）
[root@r710-1 /]# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.1.45 MySQL Community Server （GPL）Type "help;" or "h" for help. Type "c" to clear the current input statement.mysql>GRANT ALL PRIVILEGES ON *.* TO "root"@"%" IDENTIFIED BY "rootpassword" WITH GRANT OPTION; Query OK, 0 rows affected （0.00 sec）mysql>GRANT ALL PRIVILEGES ON *.* TO "root"@"localhost" IDENTIFIED BY "rootpassword" WITH GRANT OPTION; exit
Bye
[root@r710-1 /]# mysql -u root -p ---------------------------------3---------------------------------当用户在执行mysql时报错
"ERROR 2002 （HY000）: Cant connect to local MySQL server through socket /tmp/mysql.sock （2）"

原因是由于mysql 的mysql.sock 默认是在/var/lib/mysql/mysql.sock下，但linux系统总是去/tmp/mysql.sock查找，如果mysql.sock不存在，系统就会报错。

解决办法：
1.直接指定mysql通道
[root@localhost ~]# find / -name mysql.sock
/var/lib/mysql/mysql.sock
[root@localhost ~]# mysql --socket=/var/lib/mysql/mysql.sock
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2 to server version: 5.0.22

Type help; or h for help. Type c to clear the buffer.

mysql>

2. 为mysql.sock创建软连接（类似快捷方式）
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

[root@localhost ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3 to server version: 5.0.22

Type help; or h for help. Type c to clear the buffer.

mysql> Linux下php安装时未安装MySQL支持后的解决办法Linux下Oracle 11g的安装说明相关资讯 mysql

数据库服务器 MySQL （08/15/2013 06:50:23）
MySQL 5.6 GA 及逃亡潮（02/08/2013 14:36:35）
MySQL 5.5.22、5.1.62、5.0.96全线（03/22/2012 19:03:49）

MySQL Administrator连接VMWare下（05/24/2013 09:20:58）
MySQL 5.1.68 发布（02/05/2013 08:37:47）
CentOS 5.2+MySQL+Heartbeat双机互（01/29/2012 11:16:55）

本文评论查看全部评论（0）