Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/hadoop01.pid).
时间: 2023-08-27 16:16:37 浏览: 190
mysql启动时报错:Starting MySQL… ERROR! The server quit without updating PID file
根据引用和引用提供的信息,这个错误可能是由于PID文件没有写权限导致的。解决方法是给予正确的权限。你可以执行以下命令来更改权限:
1. 执行命令 "chown -R mysql:mysql /var/data",将所需目录的所有权更改为mysql用户。
2. 执行命令 "chmod -R 755 /usr/local/mysql/data",将所需目录的权限更改为755。
3. 然后重新启动mysqld服务。
另外,引用也提供了一个启动MySQL的命令示例,你可以尝试使用该命令来启动MySQL服务。命令如下所示:
nohup mysqld_safe --datadir="/mnt/mysql/data" --pid-file="/mnt/mysql/data/xxx.pid" 2>&1 &
请注意将命令中的数据目录和PID文件路径替换为适合你的实际情况的路径。希望这些信息能够帮助你解决问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [启动mysql提示:The server quit without updating PID file(…)](https://blog.csdn.net/star919402/article/details/108752128)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *2* [mysql启动报错:The server quit without updating PID file几种解决办法](https://blog.csdn.net/weixin_42272246/article/details/125534149)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
- *3* [Starting MySQL.... The server quit without updating PID file (/mnt/mysql/data/localhost.pid).](https://blog.csdn.net/sumengnan/article/details/112517646)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 33.333333333333336%"]
[ .reference_list ]
阅读全文