How to fix MySQL Shutdown Unexpectedly

How to fix MySQL Shutdown Unexpectedly - Errors that appear suddenly on XAMPP are sometimes very annoying. One example of an error when trying to run MySQL on XAMPP. This situation is even more torturous when the deadline for the task / project is approaching, while how to overcome it is still confused.

On this occasion we will discuss how to overcome errors when running MySQL in XAMPP. The error looks something like this:

In the picture can be seen the error description:

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

If we open phpmyadmin it will appear like this

How to fix MySQL Shutdown Unexpectedly

How to overcome the error is very easy, namely using the default backup folder XAMPP at the time of installation, here are the steps:

• The first step, you enter the xampp/mysql folder
• Rename the folder xampp/mysql/data to xampp/mysql/data_old
• Create a new folder xampp/mysql/data
• Copy all files in the xampp/mysql/backup folder into the xampp/mysql/data folder you just created
• Copy all existing database folders in the data_old into the data folder (except MySQL, performance_schema, and phpMyAdmin folders)
• Then copy and replace the ibdata1 file in the data_old folder into the data folder
• rerun MySQL on XAMPP
• Done, Phpmyadmin can be accessed again.

Thus the tips that I can convey this time, maybe a little short, hopefully the tips that I have shared about How to fix MySQL Shutdown Unexpectedly can be useful. That's it and thank you