MySQL shutdown unexpectedly in XAMPP. How can I fix it?

Try this one. It worked for me right away after this process.

  1. Rename the folder xampp/mysql/data to xampp/mysql/data_old (you can use any name)
  2. Create a new folder xampp/mysql/data
  3. Copy the content that resides in xampp/mysql/backup to the new xampp/mysql/data folder
  4. Copy all your database folders that are in mysql/data_old to mysql/data (except mysql, performance_schema, and phpmyadmin folders from data_old)
  5. Now copy the ibdata1 file from xampp/mysql/data_old and replace it inside xampp/mysql/data folder
  6. You can start MySQL again from control panel now

Let me know if it worked for you.

 

https://www.quora.com/MySQL-shutdown-unexpectedly-in-XAMPP-How-can-I-fix-it

Related posts:

  1. How to Change Phpmyadmin Port in XAMPP?
  2. Cara Mengatasi Error XAMPP Canot Create File C:\\xampp\xampp-control.ini Access is denied
  3. Uploading Files to S3 in PHP
  4. CSS: Transition