Starting MySQL.. ERROR! The server quit without updating PID file (/jiaoyuting/mysql/data/mysql/mysql.pid).
时间: 2023-08-28 13:22:45 浏览: 104
linux mysql 报错:MYSQL:The server quit without updating PID file
5星 · 资源好评率100%
根据引用和引用的内容,如果在启动MySQL时出现错误"ERROR! The server quit without updating PID file",可能是因为/etc/my.cnf文件中的配置问题。你可以检查一下/etc/my.cnf文件中是否有未被注释掉的skip-federated字段,如果有的话,请将其注释掉。此外,还需要确保my.cnf文件中的各项配置正确。
另外,引用提到,如果你之前在同一台机器上安装过MySQL,并且没有完全删除残余数据,可能会影响服务的启动。你可以前往MySQL的数据目录/data,查看是否存在mysql-bin.index文件,如果有的话,请将其删除。
所以,根据提供的信息,你可以按照以上步骤进行排查,以解决MySQL启动时出现的错误。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [ The server quit without updating PID file (/opt/mysql/data/mysqld.pid).问题解决](https://blog.csdn.net/InternetJava/article/details/115542290)[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^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [Starting MySQL...... The server quit without updating PID file (/data/mysql/mysql.pid).](https://blog.csdn.net/qq_35078688/article/details/116779208)[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^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文