...have been using Xampp, on and off, for years and while I'm no expert, things have been pretty smooth in the past. Yesterday, after a few month break, some further work was to be done and everything appeared to be fine. Eventually xampp was closed (via the control panel) - and nothing untowards happened here either. When Xampp was restarted today however, apache ran, but mysql failed, ...repeatedly.
The port (3306) was free. This not withstanding, it was changed for mysql to 3308. Another try, ... no joy. I've checked permissions for the mysql folders, they are OK. Passwords didn't change. Xampp vers. 7.4.9 on Win 10.
Below the xampp-control log:
16:14:33 [main] Initializing Control Panel
16:14:33 [main] Windows Version: Enterprise 64-bit
16:14:33 [main] XAMPP Version: 7.4.9
16:14:33 [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
16:14:33 [main] Running with Administrator rights - good!
16:14:33 [main] XAMPP Installation Directory: "e:\xampp\"
16:14:33 [main] Checking for prerequisites
16:14:35 [main] All prerequisites found
16:14:35 [main] Initializing Modules
16:14:35 [main] Starting Check-Timer
16:14:35 [main] Control Panel Ready
16:14:39 [Apache] Attempting to start Apache app...
16:14:39 [Apache] Status change detected: running
16:14:45 [mysql] Attempting to start MySQL app...
16:14:45 [mysql] Status change detected: running
16:14:48 [mysql] Status change detected: stopped
16:14:48 [mysql] Error: MySQL shutdown unexpectedly.
16:14:48 [mysql] This may be due to a blocked port, missing dependencies,
16:14:48 [mysql] improper privileges, a crash, or a shutdown by another method.
16:14:48 [mysql] Press the Logs button to view error logs and check
16:14:48 [mysql] the Windows Event Viewer for more clues
16:14:48 [mysql] If you need more help, copy and post this
16:14:48 [mysql] entire log window on the forums
16:15:21 [mysql] Attempting to start MySQL app...
16:15:21 [mysql] Status change detected: running
16:15:23 [mysql] Status change detected: stopped
16:15:23 [mysql] Error: MySQL shutdown unexpectedly.
16:15:23 [mysql] This may be due to a blocked port, missing dependencies,
16:15:23 [mysql] improper privileges, a crash, or a shutdown by another method.
16:15:23 [mysql] Press the Logs button to view error logs and check
16:15:23 [mysql] the Windows Event Viewer for more clues
16:15:23 [mysql] If you need more help, copy and post this
16:15:23 [mysql] entire log window on the forums
16:15:47 [Apache] Attempting to stop Apache (PID: 13800)
16:15:47 [Apache] Attempting to stop Apache (PID: 10848)
16:15:47 [Apache] Status change detected: stopped
16:15:52 [main] Deinitializing Modules
16:15:52 [main] Deinitializing Control Panel
Here the error log for mysql... I have no idea what is going on here, but clearly mysql is very sick:
Cannot find checkpoint record at LSN (1,0x5556)
2020-12-15 16:14:46 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2020-12-15 16:14:46 0 [ERROR] Plugin 'Aria' init function returned error.
2020-12-15 16:14:46 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2020-12-15 16:14:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-15 16:14:46 0 [Note] InnoDB: Uses event mutexes
2020-12-15 16:14:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-15 16:14:46 0 [Note] InnoDB: Number of pools: 1
2020-12-15 16:14:46 0 [Note] InnoDB: Using generic crc32 instructions
2020-12-15 16:14:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-15 16:14:46 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-15 16:14:46 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1399201
2020-12-15 16:14:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-15 16:14:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-15 16:14:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-15 16:14:47 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-15 16:14:47 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-15 16:14:47 0 [Note] InnoDB: Waiting for purge to start
2020-12-15 16:14:47 0 [Note] InnoDB: 10.4.14 started; log sequence number 1399210; transaction id 811
2020-12-15 16:14:47 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-12-15 16:14:47 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-15 16:14:47 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-15 16:14:47 0 [ERROR] Failed to initialize plugins.
2020-12-15 16:14:47 0 [ERROR] Aborting
Cannot find checkpoint record at LSN (1,0x5556)
2020-12-15 16:15:21 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2020-12-15 16:15:21 0 [ERROR] Plugin 'Aria' init function returned error.
2020-12-15 16:15:21 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
InnoDB: using atomic writes.
2020-12-15 16:15:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-15 16:15:21 0 [Note] InnoDB: Uses event mutexes
2020-12-15 16:15:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-15 16:15:21 0 [Note] InnoDB: Number of pools: 1
2020-12-15 16:15:21 0 [Note] InnoDB: Using generic crc32 instructions
2020-12-15 16:15:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-15 16:15:21 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-15 16:15:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-15 16:15:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-15 16:15:21 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-15 16:15:21 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-15 16:15:21 0 [Note] InnoDB: Waiting for purge to start
2020-12-15 16:15:21 0 [Note] InnoDB: 10.4.14 started; log sequence number 1399219; transaction id 811
2020-12-15 16:15:21 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2020-12-15 16:15:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-15 16:15:21 0 [Note] InnoDB: Buffer pool(s) load completed at 201215 16:15:21
2020-12-15 16:15:21 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2020-12-15 16:15:21 0 [ERROR] Failed to initialize plugins.
2020-12-15 16:15:21 0 [ERROR] Aborting
Help would be greatly appreciated, as this is starting to eat into my life. Thanks!!