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

最新推荐文章于 2024-08-20 15:04:10 发布

baidu_38558076

最新推荐文章于 2024-08-20 15:04:10 发布

阅读量1k

点赞数

分类专栏：问题记录文章标签： java

本文链接：https://blog.csdn.net/baidu_38558076/article/details/123630879

版权

当尝试通过命令行连接MySQL时出现'ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'的问题，原因是配置的socket文件不存在。解决方案是检查并修改/etc/my.cnf文件中的socket配置为'/tmp/mysql.sock'，然后重启MySQL服务，问题即可得到解决。

摘要由CSDN通过智能技术生成

当使用mysql 本地client连接mysql提示如下错误：

[root@k8s-node1 mysql]# mysql -u root -ptest1234
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

原因就是/tmp/mysql.sock文件不存在

查看/etc/my.cnf 文件配置

可以看到socket配置并不是/tmp/mysql.sock

解决：修改上面的配置为/tmp/mysql.sock

重启mysql，问题解决

[root@k8s-node1 mysql]# mysql -u root -ptest1234
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.16 MySQL Community Server - GPL

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>