[已解决]ERROR 2002 (HY000: Can’t connect to local MySQL server through socket /var/lib/mysql/mysql.sock

概要

新建库时发现数据库一个不小心导致登不上去，查看报错说是缺少这个sock文件，去网上搜报错解决方法时发现，文章里写的/usr/local/mysql目录我这里没有，我这个数据库版本是5.7的，通过find也找不到mysql.server文件，解决此问题的核心办法是要重新启动mysql服务，让其自动在/tmp文件中生成这个sock文件，所以我用下边的操作方法成功启动了mysql服务。

报错信息

[root@localhost centos7]# mysql -uroot -p
Enter password: 
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

不同之处

[root@localhost local]# find / -name mysql.server
find: ‘/run/user/1000/gvfs’: 权限不够
[root@localhost local]# find / -name mysql
find: ‘/run/user/1000/gvfs’: 权限不够
/etc/logrotate.d/mysql
/etc/selinux/targeted/active/modules/100/mysql
/etc/selinux/targeted/tmp/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql
/usr/bin/mysql
/usr/lib64/mysql
/usr/share/mysql
 

查看mysql状态

[root@localhost bin]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service -