Error: MySQL shut down unexpectedly. – Alok Kumar Nayak – Medium

If you are using XAMPP in order to use PHP, MySQL stack for web development in your Windows system.

When you try to start MySQL from XAMPP control panel, you may encounter this issue.

XAMPP Control Panel

To Solve it, Please follow the following steps.

  1. Rename folder mysql/data to mysql/data_old
  2. Make a copy of mysql/backup folder and name it as mysql/data
  3. Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders)
  4. Copy mysql/data_old/ibdata1 file into mysql/data folder
  5. Start MySQL from XAMPP control panel

Hope you will able to repair your MySQL.

Happy Coding..

Leave a Reply