重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 登录mysql报 ERROR 2002 (HY000)错误 [打印本页]

作者: 郑全 时间: 2014-11-1 22:07
标题: 登录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)

作者: 郑全 时间: 2015-4-5 12:22

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

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

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)