XAMPP – Error: MySQL shutdown unexpectedly

Posted by

Error:

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

Solution:

Step 1: Rename the folder C:\xampp\mysql\data to C:\xampp\mysql\data_old 

Step 2: Create a new folder C:\xampp\mysql\data

Step 3: Copy the content that resides in C:\xampp\mysql\backup to the new C:\xampp\mysql\data folder

Step 4: Copy all your database folders that are in C:\xampp\mysql\data_old to C:\xampp\mysql\data (skip the mysql, performance_schema, and phpmyadmin folders from C:\xampp\mysql\data_old)

Step 5: Finally copy the ibdata1 file from C:\xampp\mysql\data_old and replace it inside C:\xampp\mysql\data folder

Step 6: Now Start MySQL from XAMPP control panel

Video:

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x