How to Resolve the MySQL Shutdown Unexpectedly Error in XAMPP | Fix Error: MySQL Shutdown Unexpectedly

MySQL Shutdown Unexpectedly is common error and almost everyone faces it in XAMPP Server but in order to resolve this error what we can do is very simple

So mentioned below are the steps to resolve and fix this error:

STEP 1:  Go to C:\xampp\mysql

In this folder C:\xampp\mysql we have to locate the folder for

making simple and easy changes required to fix this issue.

STEP 2: Make a copy of data folder And Paste it within the mysql folder

In this step just right click on mouse or touchpad and just copy the data folder and paste in within mysql folder and we will get data-Copy. As we can see the pasted folder is now named as data-Copy. Now the important steps are about to begin so stay tuned.

STEP 3: Copy all the files from data-Copy and paste it within the backup folder

Now we have to copy all the files from the data-Copy folder and then paste it in the backup folder.It may prompt

a message while copying so just click on "Replace all the files in the destination". Now we are good to go.

STEP 4: Now copy ib_logfile1 , ibdata1 , ibtmp1 files from the backup folder and paste it in the data-Copy folder

As mentioned in this step just select these three files named as:  ib_logfile1 , ibtmp1 and ibtmp1 from backup and paste

it within the data-Copy folder.It may prompt a message while copying so just click on "Replace all the files in the destination". Well done we are doing great.

STEP 5: Rename the data folder as data-old and Rename the data-Copy folder as data

Now simply rename the data folder as data-old and data-Copy folder as data.

STEP 6: Now close the XAMPP control panel if it is open

Just close the XAMPP control panel if it is opened in this step.

STEP 7: Now reopen the XAMPP control panel and now start the MySQL server

Just again open the XAMPP control panel and start the MySQL server. Click on start button to start the mysql server for 9-10 times if error is getting displayed again.

STEP 8 : [IMPORTANT] Now Restart the PC or Laptop that you are using.

Now that we have tested all the PIDs, it is essential to restart PC/Laptop to make sure that we get a working PID to run our MySQL server. So lets restart the PC/Laptop.

STEP 9: Now after we have restarted the computer , again open the XAMPP Control Panel

Now open XAMPP Control Panel and then start the Apache Server and MySQL server.

STEP 10: Now MySQL Server is up and  running and your issue is resloved.

Now we have successfully resolved this issue.

 More details are in this video 

Thanks,

TY Edu-Knowledge