SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

原创

刘俊涛的博客 2017-05-09 15:26:00 博主文章分类：MYSQL ©著作权

文章标签 mysql 重启 html 文章分类 MySQL 数据库

©著作权归作者所有：来自51CTO博客作者刘俊涛的博客的原创作品，请联系作者获取转载授权，否则将追究法律责任

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

这个问题产生是因为修改my.cnf,重启服务造成的，一般没有影响。可以不用处理。

你要保守你心，胜过保守一切。

作者：刘俊涛的博客

上一篇：MySQL 中now（）时间戳用法

下一篇：1209 -The MySQL server is running with the --read-only option

提问和评论都可以，用心的回复会被更多人看到评论

发布评论

相关文章

git clone 错误 Failed to connect to github.com port 443 after 21100 ms: Couldn‘t connect to server

错误截图fatal: unable to access 'https://github.com/zichenlbl/vuepress.git/': Failed to connect to github.com port 443 after 21100 ms: Couldn't connect to server解决方法git config --global --get http.prox

git 3c 插入图片
mysql8.0.24使用ssl登录时提示SSL is required but the server doesn't support it

mysql8.0.24使用ssl登录时提示SSL is required but the server doesn't support it#SSL is required but the server doesn't support it

SSL mysql
【详解】解决远程连接mysql很慢的方法(mysql_connect打开连接慢)

解决远程连接MySQL很慢的方法（mysql_connect打开连接慢）在开发和运维过程中，有时会遇到从远程服务器连接MySQL数据库时速度非常慢的问题。这种情况不仅影响开发效率，还可能对生产环境造成负面影响。本文将探讨几种常见的解决方案，帮助优化远程连接MySQL的速度。问题描述当使用PHP的mysql_connect函数尝试从远程服务器连接到MySQL数据库时，可能会发现连接过程异常缓慢。这种

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

ps -A | grep -i mysqlkill 列出来的进程service mysqld start问题就解决了

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

mysql

mysql 数据库服务器套接字临时文件
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

o local MySQL server through socket '/tmp/mysql.sock' (2) 出现问题原因：

mysql 套接字 TCP
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

mysql 服务没开…

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

l.sock，于是建立一个软连接...

mysql 数据库软连接
【Error】ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)

在启动

mysql 数据库 linux 配置文件
【异常】ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock

当我们只行 mysql -uroot -p时，出现如下错误： bin git:(stable) mysql -uroot -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket

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

查看是否开启服务查看my.cnf cat /etc/my.cnf Example MySQL config file for small systems. This is for a system with little memory (

tools mysql sed unix html
解决 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (111)

WSL遇到的mysql问题解决方案 ERROR 2002 (HY000): Can't connect to local MyS

mysql linux 服务器重启 MySQL
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock' (2)

这种情况一般是mysql被杀掉了. 要重新启动. ps -A | grep -i mysql kill 列出来的进程 service mysql start 我的问题就解决了

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

刚装过mysql，输入mysql -uroot -p 直接回车，出现了ERROR2002(HY000):Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(2)，反复搜索原因而不得，突然service mysql restart ,之后输入mysql -uroot -

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

在linux下，登陆mysql时（mysql -uiis -p），报如下错误：ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)1、先看一下mysql是否启动 ps -ef | grep mysqld2、确定你的mys

mysql ERROR 2002 HY000 linux 权限问题
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.sock' (111)重启mysql解决、systemctl start mysqld.service

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

1.查看一下mysql的状态 systemctl status mariadb 2.启动mysql systemctl start mariadb

mysql JAVA
linux下进mysql报ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock

部署好mysql5.7，跟往常一样，mysql -uroot -p 进mysql数据库，结果报错ERROR 2002 (HY000): Can’t connect to local MySQL server through socket

原力计划新星计划数据库 mysql linux
MySQL登录报错ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

解决办法

mysql sql bash centos 4s
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

本机登陆mysql数据库，报以下错误：# mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc...

MySQL mysql oracle f5 解决方案

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯