This may be due to a blocked port, missing dependencies,

Problems with the Windows version of XAMPP, questions, comments, and anything related.

This may be due to a blocked port, missing dependencies,

Postby Nico7523 » 11. March 2023 11:07

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 !
Nico7523
 
Posts: 1
Joined: 11. March 2023 11:04
XAMPP version: 3.3.0
Operating System: Windows 10 Pro

Re: This may be due to a blocked port, missing dependencies,

Postby Almart » 12. March 2023 10:44

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 :wink: .
Almart
 
Posts: 1
Joined: 12. March 2023 10:38
XAMPP version: 3.3.0
Operating System: Windows

Re: This may be due to a blocked port, missing dependencies,

Postby richardferrym » 13. March 2023 04:08

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.
Sent from Android 15 Vanilla Ice Cream
richardferrym
 
Posts: 5
Joined: 09. March 2023 05:19
XAMPP version: 8.2.0
Operating System: Windows 11

Re: This may be due to a blocked port, missing dependencies,

Postby merc09 » 28. March 2023 08:19

Who solved the issue?
merc09
 
Posts: 1
Joined: 28. March 2023 08:16
XAMPP version: VS16
Operating System: Windows10

Re: This may be due to a blocked port, missing dependencies,

Postby Froosh » 28. March 2023 23:08

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.
User avatar
Froosh
 
Posts: 138
Joined: 27. March 2022 17:56
XAMPP version: 8.2.0
Operating System: Windows 11 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 124 guests