CentOS 7下mysqld服务启动失败且找不到错误日志：mysqld.service: main process exited, code=exited, status=1/FAILURE

你的名字 2023-02-20 13:44 212阅读 0赞

\*\*某些参考贴文：  
https://www.cnblogs.com/waycx/p/10084447.html【CentOS 7下mysqld服务启动失败终极解决方案】  
https://blog.csdn.net/huanghaifei922/article/details/54018508【The server quit without updating PID file (/usr/local/mysql/data/centos7.pid).】

# 踩坑情况 --有利于你定位此篇博文能否解决问题 #

mysqld服务无法启动，找不到日志文件。

# 具体踩坑情况 #

\*\*【踩坑！  
一直报错……  
而且找不到日志，在一般的/var/run…… /var/log…… 都没有出现过mysqld.err，/usr/local/mysql/data下也没有任何err后缀的文件，为此也用df -h清理过内存，

# 具体命令情况 #

\*\[root@192 mysql\]\# systemctl status mysqld  
● mysqld.service - MySQL Server  
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)  
Active: failed (Result: exit-code) since 日 2020-06-28 01:07:45 CST; 4s ago  
Docs: man:mysqld  
http://dev.mysql.com/doc/refman/en/using-systemd.html  
Process: 9964 ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my.cnf (code=exited, status=1/FAILURE)  
Main PID: 9964 (code=exited, status=1/FAILURE)  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.736103Z 0 \[Note\] InnoDB: Removed temporary tablespace da…btmp1"  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.736258Z 0 \[Note\] Shutting down plugin ‘PERFORMANCE\_SCHEMA’  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.736457Z 0 \[Note\] Shutting down plugin ‘MyISAM’  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.736657Z 0 \[Note\] Shutting down plugin ‘sha256\_password’  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.736686Z 0 \[Note\] Shutting down plugin ‘mysql\_native\_password’  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.737051Z 0 \[Note\] Shutting down plugin ‘binlog’  
6月 28 01:07:45 192.168.184.100 mysqld\[9964\]: 2020-06-27T17:07:45.737838Z 0 \[Note\] /usr/local/mysql/bin/mysqld: Shutdown complete

## \*\*6月 28 01:07:45 192.168.184.100 systemd\[1\]: mysqld.service: main process exited, code=exited, status=1/FAILURE ##

## 6月 28 01:07:45 192.168.184.100 systemd\[1\]: Unit mysqld.service entered failed state. ##

## 6月 28 01:07:45 192.168.184.100 systemd\[1\]: mysqld.service failed.\*\* ##

Hint: Some lines were ellipsized, use -l to show in full.\*  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70]![也出现过这种启动一会就莫名其妙挂掉的][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 1]也出现过这种启动一会就莫名其妙挂掉的

# 排查 #

到最后排查到systemctl里有一行一直出现的  
【【mysqld.service: main process exited, code=exited, status=217/USER  
【【网上有一个帖子说“看了报错日志发现原来是配置service的时候user和group设置错了！”  
当下立马检查：\[root@192 mysql\]\# vi /usr/lib/systemd/system/mysqld.service  
【【对照原来的教程文件发现自己没有把中文删除干净  
还是报错继续检查  
【【对照帖子和原来的教程文件发现还是需要从服务启动  
启动mysql服务：\[root@192 mysql\]\# service mysqld start  
【【【出现了令人心动的报错日志！！！！  
启动中……ERROR!The server quit without updating PID file (/usr/local/mysql/data/192.168.184.100.err  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 2]  
遍寻不得的错误日志文件，傻到插在my.cnf都打错横杠的/var/log……  
【【直接按照报错日志删掉错误配置项，  
![报错日志之一][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 3]报错日志之一  
![之前我的配置项，对比着开始删掉log-err这项以及其他的报错项目][log-err]之前我的配置项，对比着开始删掉log-err这项以及其他的报错项目

# 成功!!! #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 4]\*\*

# 总结 #

1.  学会查看报错日志，有针对性地查
2.  service mysqld status比systemctl status mysqld有更多内容
3.  做一件不了解的事情，查清楚比无头苍蝇一样猛冲有用得多。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200627174232716.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200627173015187.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200627174432631.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200627174006848.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70
[log-err]: https://img-blog.csdnimg.cn/20200627174046974.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20200627174347495.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0tpYWVlZQ==,size_16,color_FFFFFF,t_70