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

   在更改mysql默认的数据存储路径后，命令行启动mysql时报错：

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

报错信息表明客户端无法连接到/var/lib/mysql路径下的mysql.sock，由于存储路径已经移动到/home/data/mysql下，即已经在/etc/rc.d/init.d/mysqld文件和默认的/etc/my.cnf文件中配置了datadir指定了/home/data/mysql，所以当然找不到/var下的socket，从/usr/share/mysql中选择，copy一个*.cnf文件到/etc下改名为my.cnf,配置如下：

[client]

#password       = your_password

port            = 3306

socket         = /home/data/mysql/mysql.sock

 

# Here followsentries for some specific programs

 

# The MySQL server

[mysqld]

port            = 3306

socket         = /home/data/mysql/mysql.sock

需要注意的是client和mysqld两处的socket路径都要跟改为/home/data/mysql。保存后启动mysql服务

之后命令行键入mysql，即可通过client正常使用