[Solved] XAMPP Error: MySQL Shutdown Unexpectedly Fixed | MySQL not starting in XAMPP Server

Hi Friends! In this video, We're going to see How to solve MySQL not Starting in the XAMPP Server. Error: MySQL Shutdown Unexpectedly.

XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for scripts written in the PHP and Perl programming languages.

[VladimirMiroshnichenko]

1) rename xampp\mysql\data => xampp\mysql\data_old
2) create new folder xampp\mysql\data
3) copy everything from xampp\mysql\backup to xampp\mysql\data
4) start mysql, start apache, check phpmyadmin, stop mysql
5) copy all YOUR (skip mysql) database folders from xampp\mysql\data_old to xampp\mysql\data
6) copy file xampp\mysql\data_old\ibdata1 to xampp\mysql\data\
7) start mysql

I hope it will help somebody

[cjcro]

Thanks for this. For anyone else wondering, this actually works. I tried all the other nonsense with services, ports, etc. This fixed it. Please make sure you revert to the 3306 Port in the .ini. I got errors because I had changed it to 3307.

[azozsalem]

thank you very much. i'm working with my collage project the night before and today im planning to continue i notice that mysql is not starting and starting to panic, this is very helpful.

[fishifreelife]

This method was effective for me, but in my situation, the database was visible but the tables were not existing. To resolve this, I took an additional step and copied the old 'ibdata1' file, replacing it with the new one. This fixed the issue with the tables. I hope this solution helps too..

[abramarif]

Thank you so much buddy. It worked successfully, appreciated!

[JosephJoestar-td]

Thankyou SO MUCH!!! You save my life for helping to to fix this!

[temitopeogunji]

Finally, you gave the solution and I subscribed to your channel immediately. I watched many videos and no one seems to have the solution but you. While finding this solution, I learned many ways of solving other cases. Thanks. 👍

[andrebarbosatech]

Hey Man! You are the best! Thanks a lot!

[zabermahbub]

Thanks. Saved my life. Can't express how happy i am.

[bhaktithakurr]

Thanks A Ton for your Help It really works like a charm 😄😄

[annashaw]

Thank you!
Worked like a charm!
Also, the video was straight to the point.
Any idea what I can do to prevent this issue from happening?

[joansuarez]

Hermano eres increíble, me quería pegar un tiro por tener que reinstalar todo y perder horas de trabajo pero me has salvado la vida. Muchas gracias, de verdad.

[pawanraturi]

thanks buddy, now my xampp started working again

[sebattinyjaison]

This really fixed the thankyou for helping me 🙏

[chiaghanamamobichukwu]

Bro, thank you, you just saved a life, thanks so much 🙏

[bhavya]

brother i appreciate this content, it was very helpful thankyou

[jbrjjor]

In data_old folder i have only 13 items why

[inaxx]

thank you for making this video to help solve my problem in the office stage

[The_Beard_of_Wisdom]

fyi, if you have a wordpress setup, you will need to recreate your login credentials for the database to connect, but this does work

[ayinbilaprosperatisibange]

i must confess i usually watch and go but for this one particular video i give it a tomb up