Starting MySQL... ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid)
时间: 2023-11-03 07:52:29 浏览: 39
报错信息"Starting MySQL... ERROR! The server quit without updating PID file (/var/run/mysqld/mysqld.pid)"可能是由于PID文件的权限问题导致的。 PID文件位于/var/run/mysqld/mysqld.pid路径下,可能是该文件所在的目录没有写的权限。解决方法是给予该目录正确的权限,可以执行命令"chown -R mysql:mysql /var/run/mysqld"来改变所属用户和用户组,并且执行命令"chmod -R 755 /var/run/mysqld"来改变目录的权限。然后重新启动mysqld服务即可解决该问题。
相关问题
Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/data/mysqld.pid)
如果在/etc/my.cnf配置文件中设置了IP绑定,当网络环境发生变化导致主机IP地址改变时,启动MySQL时可能会出现错误:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysqld.pid)。
出现这个错误的可能原因有两个:
1. 数据目录权限问题:可能是/usr/local/mysql/data/数据目录下的mysql用户没有权限。解决方法是通过执行命令"chown -R mysql.mysql /usr/..."来给予该目录权限。
2. /etc/my.cnf配置文件问题:可能是该文件中的skip-federated字段未正确配置。解决方法是检查/etc/my.cnf文件中是否有没有被注释掉的skip-federated字段,如果有则立即注释掉。(注意:如果是在Windows系统下编辑该文件,注意编码可能存在乱码问题)
tarting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/var/run/mysqld.pid).
启动MySQL时,报错"Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/run/mysqld.pid)".<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [安装mysql成功后,启动时报错 Starting MySQL... The server quit without updating PID file (/opt/mysql/...](https://blog.csdn.net/weixin_47018630/article/details/119348833)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [starting MySQL...ERROR! The server quit without updating PID file(/var/run/mysqld/mysqld.pid)](https://blog.csdn.net/qq_42609381/article/details/88578537)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]