登录mysql报 ERROR 2002 (HY000)错误

郑全

 

[root@dbserver setup]# mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

原因：没有启动

[root@dbserver setup]# ps -ef|grep mysql
root      2651  2294  0 17:41 pts/0    00:00:00 grep mysql

[root@dbserver setup]# /etc/rc.d/init.d/mysql status
 ERROR! MySQL is not running

 

--手工启动mysql
[root@dbserver setup]# /etc/rc.d/init.d/mysql start
Starting MySQL.. SUCCESS!

 

--验证状态。
[root@dbserver setup]# /etc/rc.d/init.d/mysql status
 SUCCESS! MySQL running (2775)

郑全

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

 

也可能是权限问题，/usr/local/mysql/  没有赋予 mysql:mysql