Only MySQL in XAMPP in use suddenly cannot start

By | 2022-12-23
0 Comment

I used XAMPP to test some sode, but when I was going to continue the test the next day, only MySQL could not be started.

Test Environment:

  • Windows 11
  • XAMPP Version：XAMPP Control Panel v3.3.0
  • PHP Version：8.0.25
  • MySQL Version：15.1 Distrib 10.4.27-MariaDB

Error Log Analysis:

　When I checked the MySQL error log, I found the following messages.

[Note] Plugin 'FEEDBACK' is disabled.
[ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
[ERROR] Failed to initialize plugins.
[ERROR] Aborting

Based on the above error messages, it shows that there is an issue with the aria tables of the MySQL database.

Solution:

　Repair the aria tables of the MySQL database. The solution is as follows.

  1. Run the following “raia_chk.exe” command to repair the aria tables.
    • \xampp\mysql\data\mysql>..\..\bin\aria_chk.exe -r *.MAI
  2. Delete the “aria_log.*” files.
    • \xampp\mysql\data>del aria_log.*

Summarize:

After finishing the above operations, restart XAMPP, you can find that MySQL is running now.