这个是在centos6版本的时候
报错:
[root@VMUest ~]# service mysql status ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists [root@VMUest ~]# rm -f /var/lock/subsys/mysql [root@VMUest ~]# service mysql status ERROR! MySQL is not running [root@VMUest ~]# service mysql start Starting MySQL.170331 10:18:30 mysqld_safe Directory '/var/lib/mysql' for UNIX socket file don't exists. ERROR! The server quit without updating PID file (/usr/local/mysql/data/VMUest.pid).
启动MySQL服务时,会优先在/etc/目录下查找my.cnf
[root@VMUest ~]# ll /etc/my.cnf -rw-r--r--. 1 root root 251 Jan 27 05:41 /etc/my.cnf [root@VMUest ~]# cat /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql
检查/etc/my.cnf文件是否存在(存在就将其重命名/删除)
把/etc/my.cnf重命名后,MySQL服务顺利启动~