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

  • @abhishekkandari7116
    @abhishekkandari71162 жыл бұрын

    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

  • @Lextadz
    @Lextadz2 жыл бұрын

    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

  • @foldingtravelguitar
    @foldingtravelguitar2 жыл бұрын

    Ken, you're a total star. I was completely stuck until your method fixed things. Thanks for posting!

  • @aqlcr
    @aqlcr2 жыл бұрын

    Awesome information. Short and concise. Thanks

  • @FabioSouttoDev
    @FabioSouttoDev2 жыл бұрын

    Hi Ken! You saved my study in PHP, i was the same problem and learn to fix this. Thanks!

  • @goodwilljohn4919
    @goodwilljohn49192 жыл бұрын

    Ken, thank you so much for the precise and comprehensive video.

  • @ktkoshka3489
    @ktkoshka34892 жыл бұрын

    This video really help me fixing my final term project. Thank you so much for this important video.

  • @danyzuhj
    @danyzuhj2 жыл бұрын

    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

    @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 😂

  • @reginaldodoprado2752
    @reginaldodoprado27526 ай бұрын

    Three days banging my head and you solved the problem in less than three minutes... u R my hero, man! 😁

  • @opensource269
    @opensource2692 жыл бұрын

    It's working fine. I faced the similar issue and your solution was awesome. Thank You

  • @GOPALS1967
    @GOPALS19672 жыл бұрын

    Thank you very much for this tutorial. It really helped as I was stuck with the same problem

  • @pushpendratomar4788
    @pushpendratomar47882 жыл бұрын

    That's a great tutorial for dev, thanks a lot Ken

  • @mosaddekh
    @mosaddekh Жыл бұрын

    Ken, you saved ! quick but very important tutorial Thanks for posting!

  • @sirroteolaoye9114
    @sirroteolaoye9114 Жыл бұрын

    The best part is replacing the folder and the data brought all the tables in phpmyadmin. Great job!

  • @syrymkhakimzhan9542
    @syrymkhakimzhan95422 жыл бұрын

    You are amazing this saved me the whole day especially when exams get soon

  • @Moonfox87
    @Moonfox872 жыл бұрын

    OMG WORKS first time without any extra issue thank you man

  • @rabelo3119
    @rabelo31192 жыл бұрын

    Great tutorial, very useful!

  • @XxguaxinimxX.
    @XxguaxinimxX.2 жыл бұрын

    April, 7. This still works! Thanks man!

  • @mtsparkore
    @mtsparkore3 жыл бұрын

    Man, you save too many hours here! Thanks a lot!

  • @andrefredericomuller
    @andrefredericomuller2 жыл бұрын

    Thanks man!! You've helped so much!!

  • @Rohit-ie4cu
    @Rohit-ie4cu2 жыл бұрын

    Thanks, i had tried every solution available online. But only your method works. Thanks a lot.

  • @LuizOtavio-we6be
    @LuizOtavio-we6be2 жыл бұрын

    Nice video, bro!! thanksss, it helped a lot

  • @haletawha
    @haletawha2 жыл бұрын

    You just made my day! Thank you!!!

  • @kevin3447
    @kevin34472 жыл бұрын

    Thank you so much!! Really helped a lot!!😊

  • @ReDBuLLREIS
    @ReDBuLLREIS2 жыл бұрын

    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

  • @shaital9
    @shaital9 Жыл бұрын

    thank you!!! I've been stuck with this for ages

  • @peppermusic2479
    @peppermusic24793 жыл бұрын

    Thanks! Excelent work!

  • @nicholaskizito4438
    @nicholaskizito44383 жыл бұрын

    Thanks for this life saving tip

  • @faizyabkhalid5181
    @faizyabkhalid51812 жыл бұрын

    Thanks, ken you have made my day😀

  • @jakubivancik8110
    @jakubivancik81102 жыл бұрын

    Thank you very much Ken :). That's exactly what I was looking for.

  • @norafguriye9611
    @norafguriye96112 жыл бұрын

    Thanks, this saved my days of sql issue.

  • @aynaarahmad
    @aynaarahmad2 жыл бұрын

    Lifesaver! Im almost cryyyyyyyy but you make me happy again :') Thank youuu!

  • @smadhavi9491
    @smadhavi9491 Жыл бұрын

    thank so much one of the most important video for xampp

  • @GaboVC
    @GaboVC3 жыл бұрын

    it helps me so much, thanks a lot!

  • @YoniaVracheva
    @YoniaVracheva2 жыл бұрын

    Thank you so much! It works and I solved the problem because of you!

  • @amrsayedmuhammad9124
    @amrsayedmuhammad91242 жыл бұрын

    thank you Ken for sharing this knowledge with us

  • @kiddhkane
    @kiddhkane2 жыл бұрын

    You're a life saver, man.

  • @VolkovDan
    @VolkovDan2 жыл бұрын

    HOLY SHIT BRO, U HELPED ME A LOT, TYSM

  • @franciscobuscariolli
    @franciscobuscariolli Жыл бұрын

    Thank you!!!! Saved my day here!!

  • @DS-Pakaemon
    @DS-Pakaemon2 жыл бұрын

    THANKS A LOT MANNNN, THIS WAS GODSENT

  • @christianrusipa5268
    @christianrusipa52682 жыл бұрын

    It has perfectly worked for me thanks!

  • @akamazi4792
    @akamazi47927 ай бұрын

    Thank you so much, your tutorial helped

  • @munna1905
    @munna19052 жыл бұрын

    thanks a lot, Bro. It worked like a charm. Saved lots of time.

  • @patryko4453
    @patryko44532 жыл бұрын

    Man! Thank you so much! You're master

  • @sophiamary1339
    @sophiamary13392 жыл бұрын

    Thank you very much sir!!! You saved my day!!

  • @ESTHERESTITXUFERNANDEZJACA
    @ESTHERESTITXUFERNANDEZJACA Жыл бұрын

    This save me today. I was bloqued since monday, and needed this to work in class. Thank u for the tutorial

  • @PlinioTeixeira
    @PlinioTeixeira Жыл бұрын

    Ótimo tutorial! Resolveu meu problema, parabém por compartilhar essa informação preciosa. 🥰

  • @kevinfunez7880
    @kevinfunez78802 жыл бұрын

    You save me, I was in my final exam and this error came up. Thanks!

  • @gabrielearaujo3013
    @gabrielearaujo3013 Жыл бұрын

    Tentei resolver durante horas, mas foi você que resolveu meu problema muito obrigado 😊😊 ✌✌

  • @rodrigo100kk

    @rodrigo100kk

    10 ай бұрын

    Eu também. Esse tuto é pika.

  • @saidjamolqosimxonov1530
    @saidjamolqosimxonov15303 жыл бұрын

    Thanks! It helped me a lot

  • @sylakkayizzi8513
    @sylakkayizzi85132 жыл бұрын

    thanx so much, i was completely stuck and confused, the video has sincerely helped me a lot, thnx so much indeed

  • @FiraFiki
    @FiraFiki3 ай бұрын

    Thanks! It works. Almost cracked my head open 😢

  • @north.thunpisit
    @north.thunpisit Жыл бұрын

    This clip can help me after I try it fro a long time, Thanks so much. 😊

  • @fernandogonzalez8795
    @fernandogonzalez8795 Жыл бұрын

    Perfect my friend! Thank you very much!

  • @kirillushakov374
    @kirillushakov3745 ай бұрын

    Thanks man! U saved a lot of time for me and all these people :) Like

  • @somabenedeksimon646
    @somabenedeksimon646 Жыл бұрын

    Saved my life, thank you Ken!

  • @esaelcastillo2413
    @esaelcastillo24132 жыл бұрын

    It works. Thanks you so much man

  • @franciscocardoso1890
    @franciscocardoso18902 жыл бұрын

    thanks for helping, u saved me a lot of hours.

  • @dhruv6623
    @dhruv66233 жыл бұрын

    Thanks bro this really helped u saved my life

  • @Ken-oh5yh

    @Ken-oh5yh

    3 жыл бұрын

    Glad to hear it

  • @harshasrivardhankapa9295
    @harshasrivardhankapa9295 Жыл бұрын

    Thank you,it helped me a lot

  • @moinshaikh177
    @moinshaikh1772 жыл бұрын

    life saving Video man thanks it finally worked

  • @ProRonald123
    @ProRonald1232 жыл бұрын

    Great video, you save my life 🧡

  • @AnwarTechn
    @AnwarTechn2 жыл бұрын

    Excellent work. Thanks

  • @vineetarora1405
    @vineetarora1405 Жыл бұрын

    WOW, Thanks a ton, the trick saved me . :)

  • @ritikpandey2001
    @ritikpandey2001 Жыл бұрын

    thank you so much really helped me :)

  • @lhddie
    @lhddie10 ай бұрын

    man , thank you so much , you helped me a lot. now i fixed the issue with your video. thanks

  • @stuartcarter7053
    @stuartcarter7053 Жыл бұрын

    Superb video. Solved my problem perfectly. Thank you

  • @SMART-GIFTING
    @SMART-GIFTING Жыл бұрын

    You saved my live!! Many thanks

  • @amruthesh
    @amruthesh2 жыл бұрын

    Thanks, Ken. It worked!

  • @reneleichel1332
    @reneleichel1332 Жыл бұрын

    Thanks Ken. Your video instruction helped me within 5 minutes to solve the problem./ GREAT!

  • @almaceciliaarreolabautista2404
    @almaceciliaarreolabautista24042 жыл бұрын

    Thank you so much bro! , you saved my life

  • @bhajansong9064
    @bhajansong90642 жыл бұрын

    Perfect ken, you saved my time

  • @al_walid-fb6br
    @al_walid-fb6br2 жыл бұрын

    Thanks! It's Helpful and working

  • @ideiassimples9428
    @ideiassimples94282 жыл бұрын

    Thank you. This video resolve my problem.

  • @virsuryaircas
    @virsuryaircas Жыл бұрын

    Thanks man saved me from huge tsunami months and months of work was there.. savior dude

  • @VincentKing89
    @VincentKing89 Жыл бұрын

    You are my Hero. Simple and Work!

  • @marufsarkar2960
    @marufsarkar2960 Жыл бұрын

    It Worked! Thanks a lot

  • @hectorribeiro9231
    @hectorribeiro9231 Жыл бұрын

    That worked for me. Thank you very much.

  • @jitendrakumarvishvakarma1547
    @jitendrakumarvishvakarma15472 жыл бұрын

    Thanks man! Worked smoothly....

  • @anastazry
    @anastazry2 жыл бұрын

    Thank you soo much for your video!

  • @guilhermerksksk
    @guilhermerksksk2 жыл бұрын

    i love you, thank you so much i was about to give up

  • @johanleon1704
    @johanleon17042 жыл бұрын

    Excelent bro, what a great video

  • @maazbinshahid649
    @maazbinshahid64910 ай бұрын

    Thanks man !!! Saved my day

  • @sophia_mary_r7914
    @sophia_mary_r79142 жыл бұрын

    Thank you very much sir. You've saved my day!!

  • @syed9846
    @syed98462 жыл бұрын

    Life saver, Thanks man, it works

  • @ZarKoiGamersFPS
    @ZarKoiGamersFPS Жыл бұрын

    Thanks my friend, you save my work!! Thanks from Brazil \ o /

  • @tranxuannhon
    @tranxuannhon7 ай бұрын

    Thanks, you save me a lot of time

  • @nourmrabet2977
    @nourmrabet29772 жыл бұрын

    Merci beaucoup pour ce tutoriel. Cela m'a vraiment aidé.

  • @be_46_madhurapatil25
    @be_46_madhurapatil252 жыл бұрын

    Thankusomuch!! I've been trying this for so long now. And finally I can say it is solved.

  • @phoebeclairelanquino860
    @phoebeclairelanquino8602 жыл бұрын

    Thank you so much for this

  • @sergiojunior7401
    @sergiojunior74016 ай бұрын

    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

    @Ken-oh5yh

    6 ай бұрын

    Much appreciated!

  • @LordLacerda
    @LordLacerda Жыл бұрын

    thanks man!! really appreciated!!!

  • @MrGaneshskc
    @MrGaneshskc2 жыл бұрын

    you saved my time. thanks a lot

  • @gabrielmalheiro4871
    @gabrielmalheiro48712 жыл бұрын

    Tks really much, you really helped me!!!!!

  • @anasofia5582
    @anasofia5582 Жыл бұрын

    Thank you very much, you save my work

  • @mdsaminyeasar5935
    @mdsaminyeasar59352 жыл бұрын

    Thank you. You saved my day.

  • @MyMineplays
    @MyMineplays7 ай бұрын

    Thank you, saved my life :)

  • @kaliarycisne6688
    @kaliarycisne66882 жыл бұрын

    Resolveu meu problema!!!!! congrats!

  • @maysm3266
    @maysm3266 Жыл бұрын

    thanks, this one is very helpful.

  • @nerdgustavo
    @nerdgustavo Жыл бұрын

    cheers from brazil, it was an amazing tutorial!

Келесі