Xampp mySQL start error?

CPANathan · Jun 23, 2022

I confident it's the 40 projects' databases I've got set up when phpmyadmin loads up, I've tried adding more ports through C:\xampp\apache\conf\ and C:\xampp\apache\conf\original\extra... Adding ports to localhost and to the Listen part.

And I'm stilling getting the original error;

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

and this from logs;

2022-06-23 13:14:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-06-23 13:14:29 0 [Note] InnoDB: Uses event mutexes
2022-06-23 13:14:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-06-23 13:14:29 0 [Note] InnoDB: Number of pools: 1
2022-06-23 13:14:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-06-23 13:14:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-06-23 13:14:29 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-23 13:14:29 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 8023645 between the checkpoint 8023645 and the end 8023636.
2022-06-23 13:14:29 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-06-23 13:14:29 0 [Note] InnoDB: Starting shutdown...
2022-06-23 13:14:29 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-06-23 13:14:29 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-06-23 13:14:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-06-23 13:14:29 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2022-06-23 13:14:29 0 [ERROR] Aborting

Any ideas on a resolution?

natural efe · Jun 23, 2022

What "Windows Event Viewer" says?

TomTheCat · Jun 23, 2022

CPANathan said:
Any ideas on a resolution?

Check this

https://stackoverflow.com/questions/18300377/how-to-solve-error-apache-shutdown-unexpectedly

lucky.sparks · Jun 23, 2022

Oh boi, this hit me back in some flashbacks when skype client was causing the issues of the xampp apache to start. It was 10 years ago or probably more tho

- 40 databases shouldn't be the issue
- phpmyadmin is really not a service that loads something in memory upon startup, its a PHP script that is served just like any website

You should check for MySQL logs to see what is happening with it. There is a chance that MySQL is already running, you should check processes under task manager.

I've tried adding more ports through

This does not sound right, better revert back those changes

BlogPro · Jun 23, 2022

CPANathan said:
I confident it's the 40 projects' databases I've got set up when phpmyadmin loads up, I've tried adding more ports through C:\xampp\apache\conf\ and C:\xampp\apache\conf\original\extra... Adding ports to localhost and to the Listen part.

And I'm stilling getting the original error;

and this from logs;

Any ideas on a resolution?

Can you share the contents of the log?

A very common xampp solutions is to just rename the data folder inside the mysql folder and recreate it and copy the contents over. Can get you the steps, but need to verify if the logs are denoting some other error.

TomTheCat · Jun 23, 2022

CPANathan said:
Any ideas on a resolution?

Also, have you somehow copied the databases? InnoDB doesn't allow this. You need to force a recovery.

https://forum.aapanel.com/d/2144-help-mysql-innodb-missing-mlog-checkpoint/2

lucky.sparks · Jun 23, 2022

CPANathan said:
Any ideas on a resolution?

Do a backup and then delete all ib_logfile files and try again.

CPANathan · Jun 23, 2022

lucky.sparks said:
Oh boi, this hit me back in some flashbacks when skype client was causing the issues of the xampp apache to start. It was 10 years ago or probably more tho

- 40 databases shouldn't be the issue
- phpmyadmin is really not a service that loads something in memory upon startup, its a PHP script that is served just like any website

You should check for MySQL logs to see what is happening with it. There is a chance that MySQL is already running, you should check processes under task manager.

This does not sound right, better revert back those changes

This sounds like a resolution to an error that might have been caused when I was ending the first Xampp task I seen in task manager after updating the config files; I'll try this first as I remember having to close 3-4 tasks while updating php.ini previously!

Thank you everyone!

TomTheCat · Jun 23, 2022

CPANathan said:
This sounds like a resolution to an error that might have been caused when I was ending the first Xampp task I seen in task manager after updating the config files; I'll try this first as I remember having to close 3-4 tasks while updating php.ini previously!

Thank you everyone!

If you don't specifically need Apache, I'd suggest you to move to Nginx, PHP, MariaDB and phpMyAdmin.

CPANathan · Jun 23, 2022

TomTheCat said:
If you don't specifically need Apache, I'd suggest you to move to Nginx, PHP, MariaDB and phpMyAdmin.

So as a rookie I'm still figuring out what exactly Xampp does; when I get a project or two going, circling back and figuring out what's going on is a fat part of my study to-do list...

You like that @Scorpion Ghost, no more schedules!

lucky.sparks · Jun 23, 2022

CPANathan said:
I'm still figuring out what exactly Xampp does

It helps you to one-click install all needed services of running/hosting websites and adds some easier management with start/stop/restart buttons

Xampp mySQL start error?

CPANathan

Elite Member

natural efe

Junior Member

TomTheCat

Elite Member

lucky.sparks

Elite Member

BlogPro

Elite Member

TomTheCat

Elite Member

lucky.sparks

Elite Member

CPANathan

Elite Member

TomTheCat

Elite Member

CPANathan

Elite Member

lucky.sparks

Elite Member

Main Menu

Marketplace

Making Money

BlackHatWorld

Other