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

学习python中的MySQLdb模块时, 发现mysql启动不了, 想办法解决:

运行环境:

• CentOS Linux release 7.3.1611 (Core)
• mysql Ver 15.1 Distrib 5.5.52-MariaDB, for Linux (x86_64) using readline 5.1(我安装的是MariaDB)

---

猜测可能的原因:

• /var/lib/mysql目录权限配置问题

• my.cnf中socket参数配置问题

  [mysqld]
  datadir=/var/lib/mysql
  socket=/var/lib/mysql/mysql.sock

• mysql服务没有启动(这也不行)

  service mysqld restartRedirecting to /bin/systemctl restart  mysqld.serviceFailed to restart mysqld.service: Unit not found.

查找了下我的系统中根本就没有mysql.sock这个文件,
而且我是以root身份登录的, 也不可能是权限的问题.
后来通过执行:mysqld_safe就可以了.

再试:

mysql -uroot -pEnter password: Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 6Server version: 5.5.52-MariaDB MariaDB Server......

参考:
http://www.linuxdiyf.com/viewarticle.php?id=75335

欢迎补充指证!