> 技术文档 > MySQL登陆报错 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ _enter password: error 2002 (hy000): can\'t connect

MySQL登陆报错 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ _enter password: error 2002 (hy000): can\'t connect

技术文档

[root@rmyylis-source01~]#mysql-uroot-p

Enterpassword:

ERROR2002(HY000):Can\'tconnecttolocalMySQLserverthroughsocket\'/tmp/mysql.sock\'(2)[mysqld]
这是MySQL连接时出现的ERROR 2002 HY000，提示无法通过socket \'/tmp/mysql.sock’连接到本地MySQL服务器的问题。

解决MySQL无法通过socket连接的步骤

1.确认MySQL服务状态

systemctl status mysql

若服务未启动，先启动服务：
```
systemctl start mysql 
```

2.检查socket文件路径

查找实际socket文件位置：
```
sudo find / -name \"mysql.sock\"
```

3.修改MySQL配置文件

编辑配置文件（通常为/etc/my.cnf或/etc/mysql/my.cnf）：

[mysqld] socket = /var/lib/mysql/mysql.sock # 与步骤2中找到的实际路径一致 [client] socket = /var