mysql doesn’t start from XAMPP Control Panel (/w administrator rights)

  apache, innodb, mysql, windows, xampp

Yesterday it worked fine , until today boot-ed up and so couldn’t start mysql..
then using command "mysql_upgrade" it trows exception : Version check failed.

Got the following error when calling the ‘mysql’ command line client
ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
FATAL ERROR: Upgrade failed

or then using executable "mysql_upgrade_Wizard" , exception : "There is no service that can be upgraded to mariadb10.4.20"
it would be good to just reset mysql..

2021-09-05 19:19:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-05 19:19:00 0 [Note] InnoDB: Uses event mutexes
2021-09-05 19:19:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-05 19:19:00 0 [Note] InnoDB: Number of pools: 1
2021-09-05 19:19:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-05 19:19:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-05 19:19:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-05 19:19:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-05 19:19:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-05 19:19:01 0 [Note] InnoDB: Setting file 'C:xamppmysqldataibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-05 19:19:01 0 [Note] InnoDB: File 'C:xamppmysqldataibtmp1' size is now 12 MB.
2021-09-05 19:19:01 0 [Note] InnoDB: Waiting for purge to start
2021-09-05 19:19:01 0 [Note] InnoDB: 10.4.20 started; log sequence number 552773; transaction id 1088
2021-09-05 19:19:01 0 [Note] InnoDB: Loading buffer pool(s) from C:xamppmysqldataib_buffer_pool
2021-09-05 19:19:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-05 19:19:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210905 19:19:01
2021-09-05 19:19:01 0 [Note] Server socket created on IP: '::'.

19:18:50  [Apache]  Attempting to start Apache app...
19:18:50  [Apache]  Status change detected: running
19:18:59  [mysql]   Attempting to start MySQL app...
19:19:00  [mysql]   Status change detected: running
19:19:02  [mysql]   Status change detected: stopped
19:19:02  [mysql]   Error: MySQL shutdown unexpectedly.
19:19:02  [mysql]   This may be due to a blocked port, missing dependencies, 
19:19:02  [mysql]   improper privileges, a crash, or a shutdown by another method.
19:19:02  [mysql]   Press the Logs button to view error logs and check
19:19:02  [mysql]   the Windows Event Viewer for more clues
19:19:02  [mysql]   If you need more help, copy and post this
19:19:02  [mysql]   entire log window on the **forums**

while in Events..

mysqld.exe: Error writing file 'C:xamppmysqldataaria_log_control' (Errcode: 9 "Bad file descriptor")
mysqld.exe: Error on close of 'C:xamppmysqldataaria_log_control' (Errcode: 9 "Bad file descriptor")
mysqld.exe: Aria engine: checkpoint failed
Fatal error: Can't open and lock privilege tables: Incorrect file format 'roles_mapping'

Source: Windows Questions

LEAVE A COMMENT