CentOS8 Mysql 启动失败解决办法

CentOS8 Mysql 启动失败解决办法

1. 问题描述

启动Mysql失败

[root@primo ~]# service mysqld startStarting 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 startStarting mysqld (via systemctl): [ OK ]