Can't connect to local MYSQL server through socket /var/lib/mysql/mysql.sock

最新推荐文章于 2019-10-24 19:45:31 发布

原创最新推荐文章于 2019-10-24 19:45:31 发布 · 409 阅读

0 ·

CC 4.0 BY-SA版权

本文针对ERROR2002（HY000）：Can't connect to local MySQL server through socket/var/lib/mysql/mysql.sock的问题，提供了具体的解决方案。通过调整my.cnf文件中的socket路径配置，确保mysqld和client配置的一致性。

问题：ERROR 2002 （HY000）： Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock

楼主直接用yum安装。，直接进入到/etc/my.cnf

默认配置添如下：

[mysqld]
socket=/var/lib/mysql/mysql.sock
[client]
socket=/var/lib/mysql/mysql.sock

一定要保证这两个地方一致，如果没有，添加这个配置即可

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

紫色的疯

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

mysql Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

m0_37449634的博客

02-07

2万+

mysql Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

weixin_33941350的博客

03-09

172

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

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

JaneYork的博客

03-28

1492

报错内容： [root@instance-teosl6ad ~]# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [root@instance-teosl6ad ~]#...

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’

记录点滴

02-20

702

mysql 已启动，但是提示： Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ /etc/my.cnf 关闭了tcp方式， socket=/tmp/mysql.sock 查找： 1、dir -lha /var/lib/ 看mysql目录的权限是否为 mysql:

Linux中安装mysql:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

kerry_55的博客

05-10

5206

启动mysql的时候报了这个错：查看是否安装了mysql,是有的；那怎么解决呢？百度找了好多解决方法~都是：先查看mysqld是否启动： /etc/rc.d/init.d/mysqld status这里我查看后又引出另一个错误信息：-bash: /etc/rc.d/init.d/mysqld: No such file or directory然后我对这个错又百度找问题解决~ 方法不说了各种不行，...

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

PzzZ的博客

05-13

411

刚刚我的数据库链接不上了查看了一下数据库状态 systemctl status mysqld inactive 挂掉了在尝试链接下数据库 mysql -u -p 就是这个错 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 '/tmp/mysql.sock'

09-09

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

Can't connect to local MySQL through socket '/tmp/mysql.sock'解决方法

09-09

标题中的问题 "Can't connect to local MySQL through socket '/tmp/mysql.sock'" 是一个常见的MySQL连接错误，通常发生在尝试通过套接字文件（socket file）连接到本地MySQL服务器时。该问题通常涉及MySQL服务未...

精选资源

Can’t connect to local MySQL through socket ‘/tmp/mysql.sock’解决方法

01-19

ERROR 2002: Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (111) 解决办法： /usr/local/mysql/bin/mysqladmin -u root > -S /var/lib/mysql/mysql.sock password 'your.passwd' ...

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服务器建立...

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

shiyilukou的博客

07-19

303

mysql 连接报错 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock 解决 sudo chown -R mysql:mysql /var/lib/mysql

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

scropio0zry的博客

03-04

1290

今天，在服务器上传war文件之后，运行tomcat之后发现出database无法解析的情况于是尝试了连接mysqlmysql -u troot -p 密码出现ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)原因可能是mysql服务停止采用重启服...

MySQL连接报错：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

BugMaker

08-20

2200

MySQL连接报错：Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)报错原因 : MySQL的service服务未打开解决方案 : 将服务打开（命令：service mariadb start ）

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’解决

aren

03-31

427

启动mysql 报错： ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 1、先查看 /etc/rc.d/init.d/mysqld status 看看m y s q l 是否已经启动. 另外看看是不是权限问题. 2...

安装mysql 报错Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

qq_39625998的博客

05-27

570

安装mysql时候报错：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)网上给的修改方法已经够多了，记得查看你是不是在root用户下进行的操作，如果不是，恭喜找到这篇文章。先切换root再执行操作，一切正常...

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

strom_xu

10-24

661

1、问题描述在客户端登录mysql报如下异常 Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111) 2、问题解决 1、确保mysql服务是否启动 2、查看内存是否充足 ...

mysql报错 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 解决办法

Keep_persistence的博客

03-26

675

1、执行命令： killall mysqld ( 直接杀死正在运行的mysqld所有进程)2、mysqld 进程kill之后，在任意目录下执行 /etc/init.d/mysql.server start等待mysql重启成功后，netstat -tnlp查看该进程是否已经起来3、mysql -uroot -pxxxxx，进入mysql...

在linux中打不开mysql显示Can t connect to local MySQL server through socket /var/lib/mysql/mysql.sock