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

亦凉 2022-03-20 13:24 175阅读 0赞

在Linux服务器上安装好mysql后登录时出现以下问题：

![20190213105522809.png][]

查找mysql.sock 文件，命令如下：

find -name mysql.sock

结果如下：

![20190213105803325.png][]

如果文件不存在，可以参考博友的这篇文章[https://blog.csdn.net/haifu\_xu/article/details/25281599][https_blog.csdn.net_haifu_xu_article_details_25281599]

文件存在，但是不存在/var/lib/mysql目录下，做一个软连接即可，在这之前先确定当前用户为root用户，命令为 whoami

![2019021311022982.png][]

由普通用户切换到root用户，su 回车，输入密码即可进入root

关闭mysql数据库，命令如下：

service mysqld stop

![20190213110717204.png][]

将/tmp/mysql.sock 设置软连接到 /var/lib/mysql/mysql.sock

命令如下：

ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

![20190213113043716.png][]

重新启动mysql

service mysqld start

![20190213113133653.png][]

重新登录mysql数据库，成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwOTM4NzA1_size_16_color_FFFFFF_t_70][]

如果还是报ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'（2）

则打开my.cnf文件，

查找my.cnf文件的位置

find -name my.cnf

我的文件位置是 ./etc/my.cnf

打开my.cnf文件

vim /etc/my.cnf

![20190213153234939.png][]

找到\[mysqld\],在它的后面任意下一行添加如下代码：

socket=/var/lib/mysql/mysql.sock

![20190213161032587.png][]

保存退出，重启mysql

[20190213105522809.png]: /images/20220320/20f1a54f679245c1a10db2fad06b4d6d.png
[20190213105803325.png]: /images/20220320/be2269a89d534670bcee7eb678ad2473.png
[https_blog.csdn.net_haifu_xu_article_details_25281599]: https://blog.csdn.net/haifu_xu/article/details/25281599
[2019021311022982.png]: /images/20220320/fc2972370a8c4325b3a5e62170e16931.png
[20190213110717204.png]: /images/20220320/b485da1a76e94533b7a4754550ebdbdb.png
[20190213113043716.png]: /images/20220320/cb3ef0126d3f41d3a9a4a08cfef690a4.png
[20190213113133653.png]: /images/20220320/b9714af987124d86b517117e03ac12c1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwOTM4NzA1_size_16_color_FFFFFF_t_70]: /images/20220320/f0f7ce51e97f470f8865af64dbfce823.png
[20190213153234939.png]: /images/20220320/15f0eacc5f6c4fe8a4f025b438fa7119.png
[20190213161032587.png]: /images/20220320/19534378d6c142d3a80376504b9e0272.png

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 MySQL报错'ERROR 2002 (HY000): Can't connect to local MySQL server through'

相关【mysql报错】ERROR 2002 (HY000) Can‘t connect to local MySQL server through socket ‘tmpmysql

相关【Linux_Mysql】ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var

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

相关 ERROR 2002 (HY000): Can't connect to local MySQL server through socket

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

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

相关 MySQL：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/

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

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