XAMPP 版本3.2.4
之前就碰到过一次，直接重装xampp，问题解决。
今天又碰到了，
15:48:46 [mysql] Error: MySQL shutdown unexpectedly.15:48:46 [mysql] This may be due to a blocked port, missing dependencies, 15:48:46 [mysql] improper privileges, a crash, or a shutdown by another method.15:48:46 [mysql] Press the Logs button to view error logs and check15:48:46 [mysql] the Windows Event Viewer for more clues15:48:46 [mysql] If you need more help, copy and post this15:48:46 [mysql] entire log window on the forums
查看mysql_error.log
-08-05 15:06:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions-08-05 15:06:57 0 [Note] InnoDB: Uses event mutexes-08-05 15:06:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11-08-05 15:06:57 0 [Note] InnoDB: Number of pools: 1-08-05 15:06:57 0 [Note] InnoDB: Using SSE2 crc32 instructions-08-05 15:06:57 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 1, chunk size = 128M-08-05 15:06:57 0 [Note] InnoDB: Completed initialization of buffer pool-08-05 15:06:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.-08-05 15:06:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables-08-05 15:06:57 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...-08-05 15:06:57 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.-08-05 15:06:57 0 [Note] InnoDB: Waiting for purge to start-08-05 15:06:57 0 [Note] InnoDB: 10.4.18 started; log sequence number 300378; transaction id 8-08-05 15:06:57 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool-08-05 15:06:57 0 [Note] Plugin 'FEEDBACK' is disabled.-08-05 15:06:57 0 [Note] InnoDB: Buffer pool(s) load completed at 210805 15:06:57-08-05 15:06:57 0 [Note] Server socket created on IP: '::'.InnoDB: using atomic writes.
按照/4php/p/4122210.html删除文件后，依然不能启动。
在xampp面板上重装mysql，又出现如下报错：
-08-05 15:07:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions-08-05 15:07:42 0 [Note] InnoDB: Uses event mutexes-08-05 15:07:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11-08-05 15:07:42 0 [Note] InnoDB: Number of pools: 1-08-05 15:07:42 0 [Note] InnoDB: Using SSE2 crc32 instructions-08-05 15:07:42 0 [Note] InnoDB: Initializing buffer pool, total size = 1G, instances = 1, chunk size = 128M-08-05 15:07:43 0 [Note] InnoDB: Completed initialization of buffer pool-08-05 15:07:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.-08-05 15:07:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables-08-05 15:07:43 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...-08-05 15:07:43 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.-08-05 15:07:43 0 [Note] InnoDB: Waiting for purge to start-08-05 15:07:43 0 [Note] InnoDB: 10.4.18 started; log sequence number 300405; transaction id 8-08-05 15:07:43 0 [Note] Plugin 'FEEDBACK' is disabled.-08-05 15:07:43 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool-08-05 15:07:43 0 [Note] InnoDB: Buffer pool(s) load completed at 210805 15:07:43-08-05 15:07:43 0 [Note] Server socket created on IP: '::'.-08-05 15:07:43 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed-08-05 15:07:43 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed-08-05 15:07:43 0 [ERROR] AbortingInnoDB: using atomic writes.
直接把db文件夹标为crash，并且修复失败。
最后按照/questions/56847804/xampp-mysql-service-crash-after-reboot的方法：
点击xampp面板上的Shell按钮进入命令框，输入命令：
mysqld –-console –-skip-grant-tables –-skip-external-locking
保持上一个窗口不关闭，重新在面板上点开一个Shell，输入指令：
mysqlcheck -r --databases mysql --use-frm
等命令窗口不再变化，再关闭命令窗口，重新启动xampp，问题解决。
到现在，已经可以正常打开mysql server 了。
如果出现“table *** doesn't exist in engine”,在db文件夹中发现文件都在。这时候需要在回收站中找到删除的ibdata1文件，还原ibdata1，记得是最早删除的那个。
还原后，重启mysql，打开navicate，终于回来了。
转载请注明出处！
