mysql意外关闭xampp_XAMPP本地环境MySQL意外关闭无法启动

MySQL错误日志15:08:24 [mysql] Error: MySQL shutdown unexpectedly.

15:08:24 [mysql] This may be due to a blocked port, missing dependencies,

15:08:24 [mysql] improper privileges, a crash, or a shutdown by another method.

15:08:24 [mysql] Press the Logs button to view error logs and check

15:08:24 [mysql] the Windows Event Viewer for more clues

15:08:24 [mysql] If you need more help, copy and post this

15:08:24 [mysql] entire log window on the forums

说明

在我们启动xampp时，发现Apache可以正常启动；而MySQL却不能正常运行，我们称它为MySQL意外关机。这是由于端口被占用，或者缺少运行特权，崩溃而导致MySQL数据库意外关闭···

解决办法：

在xampp软件界面找到MySQL组件，点击组件右侧下的config按钮，点击my.ini打开mysql配置文件

在mysql配置文件内搜索到[mysqld]所在行，在其下方插入

[mysqld]

““`innodb_force_recovery = 4

即可解决