首页 > 技术文章 > ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

lvhanzhi 2019-03-06 15:04 原文

centos7.5 连接数据库失败

问题:

[root@jumpserver ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

解决办法:

[root@jumpserver ~]# ps -A|grep -i  mysql
 13284 ?        00:00:00 mysqld_safe
 13422 ?        00:01:33 mysqld
[root@jumpserver ~]# kill 13284 
[root@jumpserver ~]# kill 13422
[root@jumpserver ~]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@jumpserver ~]# ps -A|grep -i  mysql
[root@jumpserver ~]# systemctl start mariadb
[root@jumpserver ~]# systemctl enable mariadb
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
[root@jumpserver ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.60-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

推荐阅读