CentOS8 Mysql 启动失败解决办法

1. 问题描述

启动Mysql失败

[root@primo ~]# 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.
[FAILED]

2. 原因分析

查看Mysql日志

Can't start server: can't check PID filepath: No such file or directory

原来时Mysql启动时没找到PID filepath，通过命令cd /var/run/进入文件夹，发现没有mysqld文件夹，导致启动失败

3. 解决办法

#1. 新建mysqld 文件夹

[root@primo run]# mkdir /var/run/mysqld/

#2. 修改操作权限

[root@primo run]# chown mysql.mysql /var/run/mysqld/

#3.重启mysql，此时可以正常启动了

[root@primo run]# service mysqld start
Starting mysqld (via systemctl):  [  OK  ]