Tutorial, Xampp

Resolve XAMPP Error: MySQL Shutdown Unexpectedly

1 min read

MySQL Shutdown Unexpectedly is usually caused by using the same port in another application running on the same device as XAMPP itself.
The error usually appears like this:

MySQL shutdown unexpectedly

Here are the steps that I have successfully tried.

  1. Rename the c:\xampp\mysql\data folder to c:\xampp\mysql\data_old (or feel free to change to another name).
  2. Create a new folder c:\xampp\mysql/data.
  3. Copy all folders or files in mysql\backup to the newly created folder ,mysql\data.
  4. Copy all database folders that are in mysql\data_old to mysql\data (skip the mysql, performance_schema, and phpmyadmin folders from data_old).
  5. Finally, copy the ibdata1 file from mysql\data_old and replace it in the mysql\data folder .
  6. Start MySQL from the XAMPP control panel.

After the last step, XAMPP should be ready to use again.

Good luck. Comment below if there are any problems 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

× Chat