Starting MySQL... ERROR! The server quit without updating PID file /var/run/mysql/localhosts_241.pid

曾经终败给现在 2023-06-17 08:57 19阅读 0赞

liunx启动mysql服务报

![20191128124704822.png][]

Starting MySQL... ERROR! The server quit without updating PID file (/var/run/mysql/localhosts\_241.pid)

1、查看启动状态

systemctl status mysqld

![20191128125049249.png][]

查看  目录 /var/run/mysql/ （这里你查看的你一个报错目录位置）是否存在，不存在创建目录，并授权

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MTMwOTgz_size_16_color_FFFFFF_t_70][]

如果不存在就创建该文件夹

#根目录执行
    mkdir /var/run/mysql
    
    #在var/run目录下执行
    mkdir mysql

.该目录存在后  授权

chown -R mysql:mysql /var/mysql/

之后mysql启动服务OK

**其它原因：**

1、

找到/var/log/mysqd.log  
查看包含最后几行包含error的行；  
\[ERROR\] Unix socket lock file is empty /tmp/mysql.sock.lock.  
\[ERROR\] Unable to setup unix socket lock file.  
\[ERROR\] Aborting

解决方法：

删除该文件

rm  -rf /tmp/mysql.sock.lock

启动：systemctl start mysqld 。即可启动成功。

2、  
\[ERROR\] InnoDB: Ignoring the redo log due to missing MLOG\_CHECKPOINT between the checkpoint 41054650 and the end 41056501.  
\[ERROR\] InnoDB: Plugin initialization aborted with error Generic error.  
\[ERROR\] Plugin 'InnoDB' init function returned error.  
\[ERROR\] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.  
\[ERROR\] Failed to initialize plugins.  
\[ERROR\] Aborting  
失败原因：因为ib\_logfile文件中记录些innodb引擎非常有用的信息比如说默认的innodb默认的配置信息，在未正常关闭server情况下，重启后的server不支持innodb引擎。

解决方法：

找到mysql的安装目录，比如：cd /usr/local/mysql/data;  
 删除ib\_logfile文件：

rm -f ib_logfile*

启动：systemctl start mysqld

[20191128124704822.png]: https://img-blog.csdnimg.cn/20191128124704822.png
[20191128125049249.png]: https://img-blog.csdnimg.cn/20191128125049249.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MTMwOTgz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191128123158108.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3MTMwOTgz,size_16,color_FFFFFF,t_70