How to solve XAMPP MySQL shutdown unexpectedly Error

5 January 2024   21144
Comments 2
XAMPP MySQL Service Error shutdown unexpectedly

If you are going to start MySQL on XAMPP and face with issue, gives the following error:

  [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

 

Here is the solution:

Rename the folder mysql/data to mysql/data_old
Make a copy of mysql/backup folder and name it as mysql/data (like before you had data folder name)
After that, copy all your database folders except mysql, performance_schema and phpmyadmin folders from mysql/data_old into mysql/data 
Copy mysql/data_old/ibdata1 file into mysql/data folder
Now open the XAMPP control panel to start the MySQL service and works fine !

Comments

  1. Easy solution and works fine for me, thank you so much brother.

  2. Wow easy and great solution !

Enter your comment below. Fields marked * are required. You must preview your comment before submitting it.