MySQL shuts down as soon it starts

[Perrorist]

Here's the log:

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

I don't know enough to take corrective action.

[Perrorist]

Here is the solution:

https://www.youtube.com/watch?v=bjgFTM-oC-o

[Froosh]

It appears that recent versions of XAMPP/MySQL are susceptible to this kind of issue when MySQL runs as a regular process. That was my experience, at least.

I would suggest that you configure at least MySQL to run as a Windows Service. I did this several months back and have not had any issues with MySQL since then. You can manually configure the services to not auto-start either via the Windows Services management console, or if you prefer possibly a script.