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

最新推荐文章于 2023-03-05 05:58:57 发布

U__F_O

最新推荐文章于 2023-03-05 05:58:57 发布

阅读量176

点赞数

本文链接：https://blog.youkuaiyun.com/U__F_O/article/details/88796743

版权

在我连接阿里云数据库时报错“ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'，进入tmp目录，删除该目录下的mysql.sock文件，再输入命令service mysqld restart即可解决

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

U__F_O

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

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

qq_58647543的博客

04-07

1104

MySQL登陆报错 ERROR 2002 (HY000)

MySQL出现：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决

热门推荐

chen97_08的博客

08-07

31万+

本文mysql的安装环境为win7 64位，mysql版本为MySQL5.7 问题描述：在命令行输入 mysql -u root -p 登录mysql，返回”Can't connect to MySQL server on localhost (10061)”错误意思大概就是：无法连接到“本地主机”（10061）上的MySQL服务器我自己也是在网上找了两三个小时才综合解决 1、首...

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

mysql start error ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/m...

weixin_30902675的博客

12-04

106

When I type mysql, it shows “ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)”. Then I try to start mysql service: $ service mysql start ...

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

weixin_30632899的博客

05-21

First make a backup of your /var/lib/mysql/ directory just to be safe. sudo mkdir /home/<your username>/mysql/ cd /var/lib/mysql/ sudo cp * /home/<your username>/mysql/ -R Next purge M...

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

执子之手0038的博客

07-06

622

连接mysql数据库时出现如下错误：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)可能的解决办法 1）确定自己安装的mysql是mysql-server而不是mysql-client。 2）查看mysql-server是否启动（我的问题就是因为没有启动），若没

[已解决]2002-can‘t connect to server on 192.168.xx.xx（10061）MySQL数据库无法远程连接

weixin_43608968的博客

03-05

1万+

navicat无法连接到远程MySQL数据库的情况，出现以上问题

阿里云报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock’

bjwindy的博客

02-01

4990

事情是这样的，早上升级了一下我的高配版的阿里云，访问网站的时候突然打不开了，就用ssh连接服务器看一下是哪儿出了问题，结果在重启数据库服务的时候报错：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/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文件）...

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

01-07

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 的异常。是用dmg直接安装的以为安装包又出现了奇奇怪怪的错误，正欲卸载该版本时找到了我的问题的关键。解决...

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 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' ...

Caused by: java.net.ConnectException: Connection refused: connect并且ERROR 2002 (HY000): Can‘t connect

qq_55278081的博客

12-16

1049

如果IDEA报这个错误：Caused by: java.net.ConnectException: Connection refused: connect并且你发现你无法使用navicat连接上数据库了，navicat报这个错误：2002-Can't connect to server on '39.106.40.86'(10061)并且连接阿里云服务器里面的的MySQL数据库报这个错误：那么你只需要按照这个方式解决：# 第一步：进入到到mysql的安装目录，我的是：/usr/local/mysql，不用去

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

Baimoc

09-21

5万+

一、错误现场还原：下面我们通过三种方式来连接，然后观察提示的错误信息： 1、直接使用“mysql”命令，不带主机名参数； 2、使用带了主机名“localhost”参数的“mysql -h localhost”命令； 3、使用带了主机名“127.0.0.1”参数的“mysql -h 127.0.0.1”命令。 1、[root@lam7 opt]# mysql ERROR 2002 ...

MySQL登陆失败：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mys

Do-Program的专栏

01-16

4388

mysqld(mysql-server)安装完成后，执行mysql会登陆失败：ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 环境：CentOS 6.5 64bit 解决办法：需要先用root权限执行： /etc/init.d/

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

A_big_fish的博客

06-17

251

linux系统下的mysql 访问出现 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' 解决方法：删除/var/lib/mysql/mysql.sock 这个文件，重新启动mysql即可 ...

【转】运行mysql报错ERROR 2002 (HY000): Can\'t connect to local MySQL server through socket[已解决]

linuxchyu的专栏

11-27

1891

rhel5.1安装mysql后在终端运行mysql报错：[root@localhost ~]# mysqlERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)第一次安装mysql，难道是我安装有问题？我是通过源码包编译安装的，于是我又下载最新的rp

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

Morning_G的博客

04-17

751

ps -A | grep -i mysql kill 列出来的进程 service mysql start 我的问题就解决了 centos6启动mysql 报错： ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) 1、先查看 /etc/rc.d...

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