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

即可解决