How To Fix the XAMPP Error: MySQL shutdown unexpectedly
Ғылым және технология
If you're experiencing an issue with XAMPP when attempting to run MySQL on Windows 10 x64 and it shuts down unexpectedly, follow these steps to resolve the issue:
1. Change the name of the "mysql/data" folder to "mysql/data_old".
2. Create a new folder named "mysql/data".
3. Transfer the contents of "mysql/backup" to the newly created "mysql/data" folder.
4. Move all database folders from "mysql/data_old" to "mysql/data", excluding the "mysql", "performance_schema", and "phpmyadmin" folders.
5. Replace the "ibdata1" file in the "mysql/data" folder with the one from "mysql/data_old".
6. Finally, start MySQL from the XAMPP control panel.
Note: XAMPP automatically creates backups, which can be found in the folder where it was installed.
The "MySQL shutdown unexpectedly" error is most often caused by a conflict with another program or a problem with the MySQL configuration. Check if there is any other application already using the same port (usually 3306) that MySQL is configured to run on. Port conflicts can cause MySQL to shut down. You can change the MySQL port in the XAMPP configuration if needed.
Пікірлер: 637
This is one of the most important video for a PHP Dev working on Windows environment. Thank you Ken for sharing this knowledge with us
I used to work with Wamp for like 5 years, recently change my laptop and start using Xampp instead. Worst mistake that I've ever done. Less than 2 months and mysql crashed this way, spend 2 hours until I found your video... thanks a lot, man! You just save me
Ken, you're a total star. I was completely stuck until your method fixed things. Thanks for posting!
Awesome information. Short and concise. Thanks
Hi Ken! You saved my study in PHP, i was the same problem and learn to fix this. Thanks!
Ken, thank you so much for the precise and comprehensive video.
This video really help me fixing my final term project. Thank you so much for this important video.
Sir you have saved my life! i had the issue 2 hours before i had to take my final exam and this worked like a charm!
@uttamtidake600
4 ай бұрын
This is very worst situation and we in the very stressful condition in our exam time. I do my project in php i have to submit my project early coming days iam happy to get this solution if any badluck happen i have this solution 😂
Three days banging my head and you solved the problem in less than three minutes... u R my hero, man! 😁
It's working fine. I faced the similar issue and your solution was awesome. Thank You
Thank you very much for this tutorial. It really helped as I was stuck with the same problem
That's a great tutorial for dev, thanks a lot Ken
Ken, you saved ! quick but very important tutorial Thanks for posting!
The best part is replacing the folder and the data brought all the tables in phpmyadmin. Great job!
You are amazing this saved me the whole day especially when exams get soon
OMG WORKS first time without any extra issue thank you man
Great tutorial, very useful!
April, 7. This still works! Thanks man!
Man, you save too many hours here! Thanks a lot!
Thanks man!! You've helped so much!!
Thanks, i had tried every solution available online. But only your method works. Thanks a lot.
Nice video, bro!! thanksss, it helped a lot
You just made my day! Thank you!!!
Thank you so much!! Really helped a lot!!😊
Thank you so much i was always having this problem and losing my time searching how to fix this and this video is the easiest way
thank you!!! I've been stuck with this for ages
Thanks! Excelent work!
Thanks for this life saving tip
Thanks, ken you have made my day😀
Thank you very much Ken :). That's exactly what I was looking for.
Thanks, this saved my days of sql issue.
Lifesaver! Im almost cryyyyyyyy but you make me happy again :') Thank youuu!
thank so much one of the most important video for xampp
it helps me so much, thanks a lot!
Thank you so much! It works and I solved the problem because of you!
thank you Ken for sharing this knowledge with us
You're a life saver, man.
HOLY SHIT BRO, U HELPED ME A LOT, TYSM
Thank you!!!! Saved my day here!!
THANKS A LOT MANNNN, THIS WAS GODSENT
It has perfectly worked for me thanks!
Thank you so much, your tutorial helped
thanks a lot, Bro. It worked like a charm. Saved lots of time.
Man! Thank you so much! You're master
Thank you very much sir!!! You saved my day!!
This save me today. I was bloqued since monday, and needed this to work in class. Thank u for the tutorial
Ótimo tutorial! Resolveu meu problema, parabém por compartilhar essa informação preciosa. 🥰
You save me, I was in my final exam and this error came up. Thanks!
Tentei resolver durante horas, mas foi você que resolveu meu problema muito obrigado 😊😊 ✌✌
@rodrigo100kk
10 ай бұрын
Eu também. Esse tuto é pika.
Thanks! It helped me a lot
thanx so much, i was completely stuck and confused, the video has sincerely helped me a lot, thnx so much indeed
Thanks! It works. Almost cracked my head open 😢
This clip can help me after I try it fro a long time, Thanks so much. 😊
Perfect my friend! Thank you very much!
Thanks man! U saved a lot of time for me and all these people :) Like
Saved my life, thank you Ken!
It works. Thanks you so much man
thanks for helping, u saved me a lot of hours.
Thanks bro this really helped u saved my life
@Ken-oh5yh
3 жыл бұрын
Glad to hear it
Thank you,it helped me a lot
life saving Video man thanks it finally worked
Great video, you save my life 🧡
Excellent work. Thanks
WOW, Thanks a ton, the trick saved me . :)
thank you so much really helped me :)
man , thank you so much , you helped me a lot. now i fixed the issue with your video. thanks
Superb video. Solved my problem perfectly. Thank you
You saved my live!! Many thanks
Thanks, Ken. It worked!
Thanks Ken. Your video instruction helped me within 5 minutes to solve the problem./ GREAT!
Thank you so much bro! , you saved my life
Perfect ken, you saved my time
Thanks! It's Helpful and working
Thank you. This video resolve my problem.
Thanks man saved me from huge tsunami months and months of work was there.. savior dude
You are my Hero. Simple and Work!
It Worked! Thanks a lot
That worked for me. Thank you very much.
Thanks man! Worked smoothly....
Thank you soo much for your video!
i love you, thank you so much i was about to give up
Excelent bro, what a great video
Thanks man !!! Saved my day
Thank you very much sir. You've saved my day!!
Life saver, Thanks man, it works
Thanks my friend, you save my work!! Thanks from Brazil \ o /
Thanks, you save me a lot of time
Merci beaucoup pour ce tutoriel. Cela m'a vraiment aidé.
Thankusomuch!! I've been trying this for so long now. And finally I can say it is solved.
Thank you so much for this
Congratulations on the video man a lot of forums there, with a lot of meaningless theories and nonsense you were very clear and objective, congratulations leaving my like and my subscription
@Ken-oh5yh
6 ай бұрын
Much appreciated!
thanks man!! really appreciated!!!
you saved my time. thanks a lot
Tks really much, you really helped me!!!!!
Thank you very much, you save my work
Thank you. You saved my day.
Thank you, saved my life :)
Resolveu meu problema!!!!! congrats!
thanks, this one is very helpful.
cheers from brazil, it was an amazing tutorial!