Error starting MySQL

[Lasmak]

Starting MySQL produces the following error message:

8.31.21 [mysql] Error: MySQL shutdown unexpectedly.
8.31.21 [mysql] This may be due to a blocked port, missing dependencies,
8.31.21 [mysql] improper privileges, a crash, or a shutdown by another method.
8.31.21 [mysql] Press the Logs button to view error logs and check
8.31.21 [mysql] the Windows Event Viewer for more clues
8.31.21 [mysql] If you need more help, copy and post this
8.31.21 [mysql] entire log window on the forums

This has happened numerous times. I have solved the problem by reinstalling XAMPP. Is there a simpler solution to this?

[jeanneotts]

The same thing happened to me this morning. This is what the error log said:

2024-03-28 8:40:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 7552
Cannot find checkpoint record at LSN (1,0x5bb7)
2024-03-28 8:40:20 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-28 8:40:20 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-28 8:40:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-28 8:40:20 0 [Note] InnoDB: Uses event mutexes
2024-03-28 8:40:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-28 8:40:20 0 [Note] InnoDB: Number of pools: 1
2024-03-28 8:40:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-28 8:40:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-28 8:40:20 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-28 8:40:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=366372
2024-03-28 8:40:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-28 8:40:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-28 8:40:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-28 8:40:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-28 8:40:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-28 8:40:20 0 [Note] InnoDB: Waiting for purge to start
2024-03-28 8:40:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 366381; transaction id 433
2024-03-28 8:40:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-28 8:40:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-28 8:40:20 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-28 8:40:20 0 [ERROR] Failed to initialize plugins.
2024-03-28 8:40:20 0 [ERROR] Aborting
2024-03-28 8:40:27 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5304
Cannot find checkpoint record at LSN (1,0x5bb7)
2024-03-28 8:40:27 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-28 8:40:27 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-28 8:40:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-28 8:40:27 0 [Note] InnoDB: Uses event mutexes
2024-03-28 8:40:27 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-28 8:40:27 0 [Note] InnoDB: Number of pools: 1
2024-03-28 8:40:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-28 8:40:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-28 8:40:27 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-28 8:40:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-28 8:40:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-28 8:40:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-28 8:40:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-28 8:40:27 0 [Note] InnoDB: Waiting for purge to start
2024-03-28 8:40:28 0 [Note] InnoDB: 10.4.32 started; log sequence number 366390; transaction id 433
2024-03-28 8:40:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-28 8:40:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-28 8:40:28 0 [Note] InnoDB: Buffer pool(s) load completed at 240328 8:40:28
2024-03-28 8:40:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-28 8:40:28 0 [ERROR] Failed to initialize plugins.
2024-03-28 8:40:28 0 [ERROR] Aborting

[jeanneotts]

I had this line in my error log:
2024-03-28 8:40:20 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

I searched in my mysql folder and found one aria_log file.After deleting that file, mysql started.

[intspeed]

I have the same problems with MySQL. Very rare it will start coreectly, so I do not understand why this is happening randomly. I can asure that the logs are the same.
I have also repaired with options as given on internet and then it will start but there popping up other corruption errors.
At another pc installed WAMPP and it works very nice.

I have many years worked with XAMPP (easy to install, stable) but now it is no more a usable program. Please friends FIX IT!!

[josteinh]

Starting MySQL produces the following error message:

8.31.21 [mysql] Error: MySQL shutdown unexpectedly.
8.31.21 [mysql] This may be due to a blocked port, missing dependencies,
8.31.21 [mysql] improper privileges, a crash, or a shutdown by another method.
8.31.21 [mysql] Press the Logs button to view error logs and check
8.31.21 [mysql] the Windows Event Viewer for more clues
8.31.21 [mysql] If you need more help, copy and post this
8.31.21 [mysql] entire log window on the forums

This has happened numerous times. I have solved the problem by reinstalling XAMPP. Is there a simpler solution to this?

Watch this video. It worked. https://www.youtube.com/watch?v=yFVJwD2kkGM

[Lasmak]

Thank you josteinh. This works, but the cause of the problem should be fixed to prevent it from happening again.

[g2ktcf]

This is the second time this error has happened for me. The first time, this solution worked fine. However, this time it enabled MySQL to run but several of my databases' tables are listed as "in use" and all my websites show "An Error has occurred". The site log files are showing that the code is looking in a table but the table is in use so it errors out as " #1932 - Table 'zc20.customers_to_groups' doesn't exist in engine". Is there any way to fix this?

[g2ktcf]

It looks like I have data corruption in the few InnoDB tables. So this looks like an issue local to my install.