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 命令登陆上了~

巴特西

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

最新文章

热门文章