ERROR! The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid).
时间: 2023-09-09 18:09:01 浏览: 132
linux mysql 报错:MYSQL:The server quit without updating PID file
5星 · 资源好评率100%
这个错误是在启动MySQL时出现的,它指出服务器在更新PID文件时退出了。根据引用\[1\]、\[2\]和\[3\]提供的解决方法,可能的原因是数据目录或PID文件没有正确的权限。解决方法是给予相应的权限。你可以尝试执行以下命令来解决问题:
1. 给予数据目录权限:执行命令`sudo chmod -R 777 /usr/local/mysql/data/`。
2. 给予PID文件权限:执行命令`chown -R mysql:mysql /var/data`和`chmod -R 755 /usr/local/mysql/data`。
3. 如果以上方法不起作用,你可以尝试执行命令`sudo chown -R _mysql /usr/local/var/mysql`。
执行完这些命令后,重新启动MySQL,应该能够解决这个问题。
#### 引用[.reference_title]
- *1* [ The server quit without updating PID file (/usr/local/mysql/data/gujingdeMacBook-Pro](https://blog.csdn.net/weixin_38281213/article/details/105155343)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [启动MySql提示The server quit without updating PID file失败](https://blog.csdn.net/shGray/article/details/103699790)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [出现ERROR The server quit without updating PID file](https://blog.csdn.net/qq_45688439/article/details/122307218)[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^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]
阅读全文