XAMPP – MySQL shutdown unexpectedly

When i open XAMPP and start the MYSQL, MYSQL doesn’t work. It shows the error on XAMPP Control Panel like this:
[mysql] Attempting to start MySQL app…
[mysql] Status change detected: running
[mysql] Status change detected: stopped
[mysql] Error: MySQL shutdown unexpectedly.
[mysql] This may be due to a blocked port, missing dependencies,
[mysql] improper privileges, a crash, or a shutdown by another method
[mysql] Press the Logs button to view error logs and check
[mysql] the Windows Event Viewer for more clues
[mysql] If you need more help, copy and post this
[mysql] entire log window on the forums

Totally stopped the MYSQL running. I restart the xampp server many times but doesn’t work. I don’t know what happened on XAMPP Server.

Finally i found the solution. the problem is MYSQL shutdown unexpectedly.
Solution is,
1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1 file
3. restart the XAMPP server

or

1. Exit Xampp and navigate to xampp/mysql/data directory
2. delete the ibdata1, ib_logfile0,ib_logfile1,ib_logfile101 files
3. restart the XAMPP server

or

Try to check the error log at the installed location: /xampp/mysql/data/mysql_error.log

This can help you better debug the problem.
Also Note:

1. XAMPP might hit into port issue when you have skype also running.
2. There is a federated plugin issue that is common.

Only by looking at the logs, we can find the exact issue. Hope this helps.

Leave a Reply