mysql无法启动，报错Failed to start SYSV: MySQL database server的解决办法：

前言

搭建的测试系统前段时间关机了，今天重启遇到没有办法启动mysql的问题，简单分析处理找到如下解决办法，解决思路：看日志，看日志，看日志！

问题描述

直接启动 mysqld的时候报错

[root@centostest ~]# service mysqld start
Starting mysqld (via systemctl):  Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
                                                           [失败]                                                           

根据系统提示看报错

[root@centostest ~]# systemctl status mysqld.service
● mysqld.service - SYSV: MySQL database server.
   Loaded: loaded (/etc/rc.d/init.d/mysqld; bad; vendor preset: disabled)
   Active: failed (Result: exit-code) since 五 2019-10-11 12:28:21 CST; 38s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 13782 ExecStart=/etc/rc.d/init.d/mysqld start (code=exited, status=1/FAILURE)

10月 11 12:28:20 centostest systemd[1]: Starting SYSV: MySQL database server....
10月 11 12:28:21 centostest mysqld[13782]: MySQL Daemon failed to start.
10月 11 12:28:21 centostest mysqld[13782]: Starting mysqld:  [失败]
10月 11 12:28:21 centostest systemd[1]: mysqld.service: control process exited, code=exited status=1
10月 11 12:28:21 centostest systemd[1]: Failed to start SYSV: MySQL database server..
10月 11 12:28:21 centostest systemd[1]: Unit mysqld.service entered failed state.
10月 11 12:28:21 centostest systemd[1]: mysqld.service failed.

发现报错Failed to start SYSV: MySQL database server…
看日志/var/log/mysqld.log

2019-10-11T04:30:39.939929Z 0 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13 - Permission denied)
2019-10-11T04:30:39.939950Z 0 [ERROR] Can't start server: can't create PID file: Permission denied

解决问题直接看这里

创建目录，修改权限

[root@centostest ~]# mkdir -p /var/run/mysqld/
[root@centostest ~]#  chown mysql.mysql /var/run/mysqld/

再次尝试，成功重启

[root@centostest ~]# service mysqld start
Starting mysqld (via systemctl):                           [  确定  ]