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

来源:互联网 发布:战争之王原型 知乎 编辑:程序博客网 时间:2024/06/02 05:04

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

错误提示:

root@localhost ~]# mysql--socket=/tmp/mysql.sock

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

解决方法:

由于mysql 默认的mysql.sock 是在/var/lib/mysql/mysql.sock,但linux系统总是去/tmp/mysql.sock查找,所以会报错

[root@localhost ~]# find / -namemysql.sock

/var/lib/mysql/mysql.sock

把/var/lib/mysql/mysql.sock添加到/etc/my.cnf

0 0
原创粉丝点击