Can‘t connect to local MySQL server through socket ‘/usr/local/mysql/mysql.sock‘

最新推荐文章于 2024-06-18 18:07:23 发布
最新推荐文章于 2024-06-18 18:07:23 发布
阅读量1.1k 收藏 3
点赞数 1
分类专栏： MySQL linux
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_38750144/article/details/113250033
版权

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

linux 进入mysql文件执行 mysql -uroot -p 输入密码进入mysql报以上错误

重启服务器执行以下操作

原因：缺少mysql.sock文件
1.进入mysql/bin目录，执行：./mysqld_safe  --user=mysql --basedir=/usr/local/mysql  --datadir=/usr/local/mysql/data &
此时会在mysql目录下生成一个mysql.sock文件
2.进入mysql目录执行：service mysqld start，就能进入到mysql数据库
青天紫魂
关注
专栏目录
Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock
后端开发
05-27 804
这个错误让我犯难，折腾了好几个小时 网上去搜索，一大片的内容都是这个 http://hi.baidu.com/lewutian/blog/item/a361a59b6b0480bec9eaf4c5.html 可以看出是相互抄袭的结果 引用 启动mysql 报错： ERROR 2002 (HY000): Can’t connect to local MySQL server through so
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的解决方法
weixin_34112900的博客
04-17 6506
mysql，mysqldump，php连接mysql服务常会提示下面错误： 1 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 产生此问题的原...
mysql Can't connect to local MySQL server through socket '/usr/local/mysl'
七彩阳光java
09-13 210
如果人品不好的话，在centos上用源码安装个mysql着实是个巨大工程 在这上面的问题全是以递归式拔萝卜带泥的式出现的， 其中一个 出现Can't connect to local MySQL server through socket '/tmp/mysql.sock'终于解决,记录一下. 在安装mysql时已经指定了目录为/usr/local/mysql,而生成的my.cnf里，...
【MySQL安装】—报错“Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘”
最新发布
sodaloveer的博客
06-18 3288
【MySQL安装】—报错“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/run/mysqld/mysqld.sock'
kf_panda
10-23 642
今天服务器遇到了一个很熟悉的问题 输入 #mysql -u root -p   ERROR 2002 (HY000):Can't connect to local MySQL server     随即上网找寻答案   根据大家提供的方法我逐一尝试   方案1.  1.#ps -A|grep mysql    显示类似：   1829 ?        00:00:00
连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
feimo
03-28 4084
1.如果确认mysql服务正常运行，还提示文章标题的此错误，那就是“/etc/my.cnf”配置文件的问题了。解决办法是修改“/etc/my.cnf”配置文件，在配置文件中添加“[client]”选项和“[mysql]”选项，并使用这两个选项下的“socket”参数值，与“[mysqld]”选项下的“socket”参数值，指向的socket文件路径完全一致。如下： [mysqld] datadi
mysql连接时报错：Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'
lizexingSpark的博客
02-23 1089
mysql连接时报错：Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock' 修改 /etc/my.cnf下的文件配置： [mysqld] port = 3306 basedir = /var/lib/mysql datadir=/var/lib/mysql socke
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 /usr/local/mysql/mysql.sock (2)
09-07
mysql --socket=/path/to/mysql.sock ``` 请将 `/path/to/mysql.sock` 替换为正确的 socket 路径。如果找不到正确的 socket 路径，可以尝试重新安装 MySQL 或者检查 MySQL 的配置文件以获取更多信息。
错误集ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/usr/local/mysql/mysql.so
零下二度的博客
03-03 803
目录
MySQL 启动失败：Can‘t connect to local MySQL server through socket ‘/usr/local/mysql/data/mysql.sock‘
热爱数据库的小胖
07-31 2458
CentOS7 使用源码安装完 MySQL8.0.31 后，出现启动失败问题！！！
mysql启动问题ERROR 2002 ( HY000 ) : Can‘t connect to local MYSQL server through socket /usr/local/mysql/
小洪帽i的博客
07-14 4072
MYSQL启动报错：ERROR 2002 ( HY000 ) : Can’t connect to local MYSQL server through socket/ usr / local / mysql / tmp / mysql . sock ( 2 ) mysql.sock 是链接mysql的文件 报错原因是无法通过 /usr/local/mysql/tmp/mysql . sock连接上mysql 解决的办法： 重启mysql服务或机器。 复制一份mysql.sock文件到相关的目录 搜索系统
Can't connect to local MySQL server through socket '=/usr/local/mysql/mysql.sock' (2)
csdnhadoop的博客
12-26 502
[root@dev_121_21 ~]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '=/usr/local/mysql/mysql.sock' (2) [root@dev_121_21 ~]# 解决： [root@dev_121_21 ~]#  vim /root/.
mysql问题Can't connect to local MySQL server through socket '/usr/local/mysql/var/mysql.sock'
IamstudyingJava的专栏
11-29 1282
1.ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/var/mysql.sock' (2) 出现这个问题是先看看mysql.sock文件是否存在。进入该目录查看，该文件不存在，也就是丢失了。丢失的原因是因为配置文件不一致，mysql错误启动，mysqld_safe会清
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/tmp/mysql.s...
weixin_30500289的博客
11-29 138
查看是否开启服务 # ps -ef | grep mysql root 5605 5457 0 11:45 pts/2 00:00:00 grep mysql 查看my.cnf # cat /etc/my.cnf # Example MySQL config file for small systems. # # This is for a system with littl...
拔萝卜MySQL_mysql Can't connect to local MySQL server through socket '/usr/local/mysl'
weixin_29616999的博客
02-05 317
# Example MySQL config file for medium systems.## This is for a system with little memory (32M - 64M) where MySQL plays# an important part, or systems up to 128M where MySQL is used together with# oth...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值