phpmyadmin Question posted in
The official documentation can be found here.

Xampp shows MySQL shutdown unexpectedly; isn't working unless every time of reinstalling xampp, – Phpmyadmin

My Xampp server is showing "MySQL shutdown unexpectedly". I did follow some solution to this problem but still it doesn’t fix. All I have to do is every time I have to use MYSQL I uninstall and reinstall Xampp and thus it works. But need a proper demonstration and solve for the problem I am facing. It’s tedious to reinstall every time.

Tried the following the solve from this thread. Stackoverflow_Fabrizio_Valencia_Solve

  • Rename the folder mysql/data to mysql/data_old (you can use any name)

  • Create a new folder mysql/data

  • Copy the content that resides in mysql/backup to the new
    mysql/data folder

  • Copy all your database folders that are in mysql/data_old to
    mysql/data (skipping the mysql, performance_schema, and phpmyadmin
    folders from data_old)

  • Finally copy the ibdata1 file from mysql/data_old and replace
    it inside mysql/data folder

  • Start MySQL from XAMPP control panel

Will be grateful if anyone helps me get through this.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Running Xampp as administrator and then re-downloading Apache and MySQL works. Figured out the solution. Nevertheless, Thanks to the great community!


  2. 0

    Please check your anti-virus may be its interrupting the xampp and also the port that xampp is using may be used by some other programs. Skype interferes with XAMPP and WAMP on port 80 so install any port checking tool and figure out which program is causing the issue.

    I Hope that your problem will be solved by addressing this.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search