XAMPP控制面板无法启动MySQL 报Aria恢复失败插件初始化错误

打开XAMPP后点击MySQL启动按钮收到错误提示，该服务此前可正常启动，当前无法运行。
XAMPP控制面板

报错核心日志：

2022-06-15  1:19:48 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2022-06-15  1:19:48 0 [ERROR] Plugin 'Aria' init function returned error.
2022-06-15  1:19:48 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2022-06-15  1:19:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-06-15  1:19:48 0 [Note] InnoDB: Uses event mutexes
2022-06-15  1:19:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-06-15  1:19:48 0 [Note] InnoDB: Number of pools: 1
2022-06-15  1:19:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-15  1:19:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-06-15  1:19:48 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-15  1:19:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-06-15  1:19:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-06-15  1:19:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-06-15  1:19:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-06-15  1:19:48 0 [Note] InnoDB: Waiting for purge to start
2022-06-15  1:19:48 0 [Note] InnoDB: 10.4.24 started; log sequence number 2555037; transaction id 2832
2022-06-15  1:19:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-06-15  1:19:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-15  1:19:48 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2022-06-15  1:19:48 0 [Note] InnoDB: Buffer pool(s) load completed at 220615  1:19:48
2022-06-15  1:19:48 0 [ERROR] Failed to initialize plugins.
2022-06-15  1:19:48 0 [ERROR] Aborting

报错根因是XAMPP内置MariaDB的Aria存储引擎事务日志损坏，导致恢复流程卡住，按以下顺序操作即可修复：

• 完全关闭XAMPP控制面板，打开任务管理器确认mysqld.exe进程已完全退出，无残留运行。
• 打开XAMPP的MySQL数据存储目录，默认路径为C:\xampp\mysql\data，找到目录下所有命名格式为aria_log.########（aria_log.后接8位数字）的日志文件，全部删除。
• 重新打开XAMPP控制面板，点击MySQL的Start按钮尝试启动，绝大多数场景下这一步即可正常拉起服务。
• 如果删除日志后仍启动失败，执行表修复操作：
  1. 按Win+R输入cmd打开命令提示符，执行命令切换到MySQL的bin目录：cd C:\xampp\mysql\bin
  2. 执行Aria表修复命令：aria_chk -r C:\xampp\mysql\data\mysql\*.MAI
  3. 等待修复命令执行完成后，再回到XAMPP启动MySQL即可。

注意：删除aria_log.########文件不会丢失已存储的业务数据库数据，这类文件是Aria引擎的事务临时日志，损坏后删除不会影响实际表数据，服务下次正常启动时会自动生成新的合法日志文件。

内容的提问来源于stack exchange，提问作者ddola