【解决】Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc

最新推荐文章于 2024-09-19 08:47:46 发布
最新推荐文章于 2024-09-19 08:47:46 发布
阅读量2.6k 收藏 1
点赞数
分类专栏： 数据库 文章标签： mysql server
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/kawayime/article/details/84004928
版权
启动mysql报错：
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
原因是，/var/lib/mysql 的访问权限问题。

shell> chown -R mysql:mysql /var/lib/mysql

接着启动服务器

shell> /etc/init.d/mysql start

解决。
kawayime
关注
专栏目录
mysql Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
m0_37449634的博客
02-07 1万+
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 136
[root@t1 /]# innobackupex --user=root --password=123456 /mydata/data InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona LLC and/or its affili...
Can‘t connect to local MySQL server through socket
最新发布
m0_38048955的博客
09-19 489
Can't connect to local MySQL server through socket
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
weixin_34259159的博客
03-13 147
MySQL在linux安装之后，连接到服务，报了下面的错误： ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 解决办法： 1、先查看 ps -ef|grep mysql 看看MySQL是否已经启动，如果启动了，尝试登录，若登录失...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
weixin_33875564的博客
11-06 65
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 原因是/var/lib/mysql 的访问权限问题。 shell> chown -R mysql:mysql /var/lib/mysql 接着启动服务器 ...
MySQL报了：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)的错
rockstar541的专栏
11-30 513
1、首先 ps-ef|grep mysql，查看具体mysql 线程命令， root xxxxx 1 0  1)22 pts/3     00:00:00  /bin/sh/    /usr/bin/mysql_safe --datadir=/var/lib/mysql  --pid-file=/var/lib/mysql/weixin.pid  /var/lib/mysql 目录下找不到my...
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’解决方法
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服务器建立...
连接mysql出现错误：Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.soc
weixin_42076409的博客
05-18 597
s
MySQL连接错误： Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.soc
liumangtutu2919的博客
01-07 6841
MySQL连接错误： Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.soc
mysql mysql.socket报错_Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.socket...
weixin_29938009的博客
02-26 1725
一、解决var/run/mysqld没有pid和sock文件MySQL下mysql.sock丢失丢失的原因一般是因为配置文件不一致的原因，mysqld 错误启动，mysqld_safe 会清除一次mysql.sock 。解决方法是：判断一般人解决故障时没有切换到mysql用户，造成权限有问题，无法创建mysql授权表，所以也就无法创建/tmp/mysql.sock 和hostname.pid文件。...
C连接mysql出现错误：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
热门推荐
Hero06206的专栏
03-02 4万+
1、先通过：service  mysqld  status  查看mysql是否启动       （没装mysql service 也可通过 /etc/rc.d/init.d/mysqld status查看）       若没启动，则启动mysql：service  mysqld  start 2、方法： 修改/etc/my.conf: [mysqld]  datadir=/usr/lo
连接mysql出现错误：Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
那些年的代码
05-13 2790
1、先通过：service mysqld status 查看mysql是否启动 （没装mysql service 也可通过/etc/rc.d/init.d/mysqld status查看） 若没启动，则启动mysql：service mysqld start 2、方法： 修改/etc/my.conf: [mysqld] datadir=/usr/local/mysql/data socket=/var/lib/mysql/mysql.sock [mysql.se...
报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock
why123wh的博客
04-14 213
报错 mysql报错 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) 解决方案 重启mariadb或者mysql
关于这个问题： Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ 
m0_37739005的博客
12-23 128
关于这个问题： Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 通过以下方法解决了 https://blog.csdn.net/HeatDeath/article/details/79065872
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc
软若石（I Will Get What I Want.）Asp.Net,Ajax,C#,Javascript
07-08 3844
 出现:Cant connect to local MySQL server through socket /var/lib/mysql/mysql.soc的错误的话.请执行命令>>>>>>>>>>>>service mysqld starty
Can t connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)
11-10
默认情况下，套接字路径应该是`/var/lib/mysql/mysql.sock`。 3. 如果MySQL服务器正在运行，但是套接字文件不存在或位于不同的位置，请使用以下命令找到套接字文件的位置： ```bash mysqladmin variables | grep...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值