Apache Friends Support Forum

Hello,

Since today i've this error message on the console

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

Yesterday, all worked fine..
After somes hours of research on the web, nothing is working... I'm really lost :/ So, anyone here can help me ? XAMPP is mandatory for my project with mysql

Thanks a lot !

Hello everybody,
I have the same problem . I share the message from the mysql_error.log file:

2023-03-12 10:35:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-03-12 10:35:48 0 [Note] InnoDB: Uses event mutexes
2023-03-12 10:35:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-12 10:35:48 0 [Note] InnoDB: Number of pools: 1
2023-03-12 10:35:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-03-12 10:35:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-03-12 10:35:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-12 10:35:48 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 20816703 between the checkpoint 20816703 and the end 20816384.
2023-03-12 10:35:48 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2023-03-12 10:35:49 0 [Note] InnoDB: Starting shutdown...
2023-03-12 10:35:49 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-12 10:35:49 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-03-12 10:35:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-12 10:35:49 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2023-03-12 10:35:49 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-03-12 10:35:49 0 [ERROR] Aborting

Thanks for your help .

i have also the same issue but fixed by removing all files (files only, folder not included) on folder C:\xampp\mysql\data except file: ibdata1, ibtmp1, ib_logfile0, and ib_logfile1. [dont forget to backup your C:\xampp\mysql\data folder, if it fails you can restore the backup.

Who solved the issue?

Search the forum messages. The solution depends on the situation, and may involve running a few shell commands. Once you have corrected the situation, you should seriously consider running MySQL as a Windows Service. The XAMPP Control Panel can help with this, but you must run it as an administrator to check the "Service" checkboxes. I've run MySQL as a Windows Service for almost a year, and have had zero database startup issues since then.