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

最新推荐文章于 2025-06-27 16:37:03 发布

weixin_46373361

最新推荐文章于 2025-06-27 16:37:03 发布

阅读量268

点赞数

CC 4.0 BY-SA版权

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

本文链接：https://blog.youkuaiyun.com/weixin_46373361/article/details/117066097

hive 同时被 2 个专栏收录

8 篇文章

订阅专栏

mysql

4 篇文章

订阅专栏

Mysql-ERROR 2002

tips one
tips two

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

tips one

>rm -rf /var/lib/mysql/mysql.sock
>service mysqld restart

tips two

>rm -rf /var/lib/mysql/mysql.sock
>mkdir /var/run/mysqld
>chown mysql.mysql /var/run/mysqld
>systemctl start mysqld

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

weixin_46373361

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

2024-02-01 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql...

qq_24428851的博客

12-27

2433

修改“/etc/my.cnf”配置文件，在配置文件中添加“[client]”选项和“[mysql]”选项，并使用这两个选项下的“socket”参数值，与“[mysqld]”选项下的“socket”参数值，指向的socket文件路径完全一致。连接Mysql ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’（）著作权归作者所有,转载或内容合作请联系作者。

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

dkdeuyv9165的博客

11-22

9203

有时候，当我们使用“mysql”、“mysqladmin”、“mysqldump”等命令管理数据库时，服务器抛出类似如下错误：一、错误现场还原：下面我们通过三种方式来连接，然后观察提示的错误信息： 1、直接使用“mysql”命令，不带主机名参数； 2、使用带了主机名“localhost”参数的“mysql -h localhost”命令； 3、使...

参与评论您还未登录，请先登录后发表或查看评论

MySQL client library is not bundled anymore

weixin_34080951的博客

07-28

361

1. Note that the MySQL client library is not bundled anymore! 问题解决：安装yum install mysql-devel 2.Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc 安装yum...

Error 2002 - Can‘t connect to local MySQL server through socket【navicat连接MariaDB】

最新发布

Yqha1的博客

06-27

303

非常棒！您执行了这个命令，并且得到了最关键的信息。这个输出结果完美地解释了问题所在，并且100%验证了我们之前的推断。

centos下mysql问题记录--ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/

nalnait的专栏

06-10

1万+

一、关于云主机的mysql最近一次云主机的服务器由于被攻击便打算重装一边mysql，彻底删除相关文件后重新安装，没想到怎么装都会出问题。再启动的时候总是出现ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)，网上很多人回答是权限的问题，这确实后一...

启动mysql报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mys

也许会有_hui的博客

05-14

693

启动mysql报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) ps aux| grep mysql kill 列出来的进程 systemctl start mariadb 我的问题就解决了 -------------...

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

09-09

在MySQL服务器的运行过程中，可能会遇到“ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'”这样的错误。这个错误提示表明，客户端试图通过Unix域套接字（socket文件）...

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

12-15

在使用MySQL时，可能会遇到一个常见的错误：“ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’”。这个错误表明客户端无法通过Unix套接字文件与本地MySQL服务器建立...

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

big_bug1的博客

12-27

1586

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)，说明 MySQL 服务未正常启动，或者其套接字文件

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

qq_58647543的博客

04-07

4417

MySQL登陆报错 ERROR 2002 (HY000)

[已解决]ERROR 2002 (HY000: Can’t connect to local MySQL server through socket /var/lib/mysql/mysql.sock

huayimy的博客

01-22

2734

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 socket '/var/lib/mysql/mysql...

andy2181的博客

09-21

1573

自己电脑远程连接后，centos服务器mysql连接不上。报错： ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 解决方法之一：将连接参数“host”的值由“localhost”改成“127.0.0.1”； ...

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

why123wh的博客

04-14

273

报错 mysql报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 解决方案重启mariadb或者mysql

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

u011034683的博客

07-23

199

环境: 阿里云服务器 Ubuntu 16.4 mysql 5.7.30 问题: 云服务器重启后, mysql服务重启失败, 出现如图情况 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 解决: 试过很多办法都不行最后重装了 sudo apt-get install mysql-server 直接重装, 并没有删除之前的mysql 和数据

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql 启动不了

码农老斑鸠的专栏

09-15

1万+

ps -A | grep -i mysql kill 列出来的进程 service mysql start 我的问题就解决了 ---------------------------------------------- Fedora8启动mysql 报错： ERROR 2002 (HY000): Can’t connect to local MySQL server through s

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

qq_44692189的博客

05-09

1145

前言在进行安装配置mysql的实验中，登录mysql是输入正确的密码，却总是报错ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)。于是，我就上网百度了一下相关的博客，发现并不能解决问题，SO ，只能从错误的原理出发，捣鼓了半天才弄好。我就将这些方法分享给大家。在Linux安装MySQL有时候会出现==[mysql]ERROR 2002 (HY000): Can’t co

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