Starting MySQL.The server quit without updating PID file

linux部署mysql数据库,启动报错:Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).

解决方法:

1. 查看报错日志没有报错信息

190419 09:52:29 mysqld_safe Starting mysqld daemon with databases from /home/mysql/data
190419 09:52:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

2. 查看是否开启 selinux.打开配置文件, 命令为: vi /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of three values:
#     targeted - Targeted processes are protected,
#     minimum - Modification of targeted policy. Only selected processes are protected.
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

SELINUX=disabled 默认关闭,排除,如果值不是disabled,请改成disabled

3. 查看是否有僵尸进程,如果有的话杀掉. 查看进程命令: ps -ef|grep mysqld , 杀掉进程命令: kill -9 进程号
   没有僵尸进程 ,排除
4. 查看硬盘是否没有空间 命令: df -h ,没问题,排除

Filesystem      Size  Used Avail Use% Mounted on
/dev/vda1        40G  2.2G   36G   6% /
devtmpfs        234M     0  234M   0% /dev
tmpfs           244M     0  244M   0% /dev/shm
tmpfs           244M  456K  244M   1% /run
tmpfs           244M     0  244M   0% /sys/fs/cgroup
tmpfs            49M     0   49M   0% /run/user/0

5. 网上有说删除多余的my.cnf之后启动成功, 查找my.cnf命令: find / -name my.cnf .删除没用的文件之后启动,继续报错.排除
6. 查看mysql运行状态报:MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED],将这个文件删除之后运行状态不报锁定文件问题了,但是启动mysql服务还是报错:

root@langguofeng data]# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
[root@langguofeng data]# ^C
[root@langguofeng data]# rm -rf /var/lock/subsys/mysql
[root@langguofeng data]# service mysql status
MySQL is not running                                       [FAILED]
[root@langguofeng data]# service mysql start
Starting MySQL.The server quit without updating PID file (/[FAILED]mysqld/mysqld.pid).
[root@langguofeng data]# 

7. 此时的我已经崩溃了,还是重新部署吧
   参考:CentOS7安装MySQL5.7
   分分钟完成mysql部署

8. 时隔多年又碰见这个破问题了，但是这次不能重新安装了。有数据啊。

检查你的my.conf配置文件，我这次是该配置文件出的问题。配置文件配置错误导致的报这个错误