[解决]ERROR 2002 (HY000): Can't connect to local MySQL server

最新推荐文章于 2024-08-21 10:16:35 发布

bedisdover

最新推荐文章于 2024-08-21 10:16:35 发布

阅读量4.4w

点赞数

分类专栏： mysql 文章标签： mysql server

本文链接：https://blog.csdn.net/bedisdover/article/details/52567269

版权

mysql 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

本文档介绍了在遇到ERROR 2002 (HY000)错误时，如何复现问题，查找mysqld.sock文件，并通过修改my.cnf配置及重启MySQL服务来解决问题，确保能够正常连接本地MySQL服务器。

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

1. 问题复现

修改mysql配置文件后,重启mysql,本地登录mysqlmysql -u root -p,结果报错

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

此时通过添加主机地址可正常访问

mysql -h 127.0.0.1 -u root -p

查看my.cnf,可以发现问题源头,[client]、[mysqld_safe]、[mysqld]中均配置了socket = /var/run/mysqld/mysqld.sock

[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir = /usr/share/mysql