mysql之ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'解决方法

LAMPP安装完成之后,mysql -u root -p连不上,报这个错误:

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

在mysql的配置文件里,/opt/lampp/etc/my.cnf, 发现了这样的配置:

[java]
<SPAN style="FONT-SIZE: 24px"># The following options will be passed to all MySQL clients 
[client] 
#password       = your_password 
port            = 3306 
socket          = /opt/lampp/var/mysql/mysql.sock 
 
# Here follows entries for some specific programs 
 
# The MySQL server 
[mysqld] 
user            = nobody 
port            = 3306 
socket          = /opt/lampp/var/mysql/mysql.sock 
 
</SPAN>

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /opt/lampp/var/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
user            = nobody
port            = 3306
socket          = /opt/lampp/var/mysql/mysql.sock

原来mysql用的套接字文件是:/opt/lampp/var/mysql/mysql.sock

于是建立了个软连接:

ln -s /opt/lampp/var/mysql/mysql.sock  /var/run/mysqld/mysqld.sock(如果mysqld目录不存在,可以用mkdir新建一个!)

现在就可以用mysql -u root -p 命令登陆上了~

上一篇:ZeroClipboard / jquery.zclip.min.js跨浏览器复制插件使用中遇到的问题解决


下一篇:Starting MySQL...The server quit without updating PID file [失败]local/mysql/data/localhost.localdomain.pid报错