无法启动mysql The server quit without updating PID file [FAILED]ata/mysql/mysql.pid

错误描述

启动MySql时，失败。错误信息如下图

[root@ecs-ca73 mysql]# service mysqld start
Starting MySQL...The server quit without updating PID file [FAILED]ata/mysql/mysql.pid).

问题分析

查看错误日志mysql-error.log

解决方案

查看 /tmp/mysql.sock.lock 信息。显示体积为0.

[root@ecs-ca73 mysql]# ll /tmp/mysql.sock.lock
-rw------- 1 mysql mysql 0 Apr 13 09:03 /tmp/mysql.sock.lock

删除该文件后，启动mysql，一切正常

[root@ecs-ca73 mysql]# rm -rf /tmp/mysql.sock.lock
[root@ecs-ca73 mysql]# service mysqld start
Starting MySQL..                                           [  OK  ]