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

以你之姓@ 2021-10-01 09:56 950阅读 0赞

新装MySQL的用户很容易遇到这个  
`ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)`  
错误

从报错来讲很自然就去看看这个文件到底存不存在

> \[root@VM\_176\_162\_centos ~\]\# cat /var/lib/mysql/mysql.sock  
> cat: /var/lib/mysql/mysql.sock: No such file or directory

这里报这个文件不存在，这个文件是mysql启动是自动生成的，大概猜测文件不存在的原因有可能有以下几种：

###### 1.mysql压根没启动，当然没这个文件，去启动mysql就好了； ######

###### 2.mysql启动了，但是没这个文件，这个应该是mysql没权限往此处写这个文件，解决权限问题重新启动就好了。 ######

## 查看mysql是否启动 ##

1.查看进程法

*这表示mysql没启动
    [root@VM_176_162_centos ~]# ps aux | grep mysqld
    root     14512  0.0  0.0   9036   668 pts/19   R+   15:52   0:00 grep --color=auto mysqld
    
    *这表示mysql启动了
    [root@VM_176_162_centos ~]# ps aux | grep mysqld 
    mysql    14394  0.4 16.8 1119216 171044 ?      Sl   15:51   0:00 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
    root     14497  0.0  0.0   9036   668 pts/19   R+   15:52   0:00 grep --color=auto mysqld

2.查看mysql的服务状态（这里是CentOS7.2+MySQL5.7下的结果，不同版本可能结果不同）

[root@VM_176_162_centos ~]# systemctl status mysqld.service
    或者
    [root@VM_176_162_centos ~]# service mysqld status

> 下面是几种结果分析：
> 
>   
> 
> 
> ![3515296-fd1050bef80759cb.png][]
> 
>   
> 
> 
> ![3515296-e9ead4bfb928bce6.png][]

[3515296-fd1050bef80759cb.png]: /images/20210811/bcbfe3eb976c4ee88e90d71b9a0a3c45.png
[3515296-e9ead4bfb928bce6.png]: /images/20210811/65d1cd91743a40b993f949cfe7a6527c.png

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'

相关【mysql报错】ERROR 2002 (HY000) Can‘t connect to local MySQL server through socket ‘tmpmysql

相关【Linux_Mysql】ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var

相关 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

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

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

相关 MySQL：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/run/mysqld/

相关 MySQL：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‘