[Solved] Error: MySql Shutdown Unexpectedly [2022 Update] MySql not starting in Xampp Server
Hello Everyone! Today in this video I am going to step by step guide you How to solve MySQL not Starting in the Xampp Server problem. i.e Error: MySql Shutdown Unexpectedly.
Get up to Free Hosting by using code "GEEKY" and you get 30% off for two months.
👉 Link: platform.cloudways.com/signup...
👉 Promo Code - GEEKY
► Follow me on Instagram: / geekyscript
► Subscribe to Geeky Script Vlog Channel: / @geekyscriptvlogs
► Subscribe to Geeky Syntax Channel: / @geekysyntax
Now 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.
Geeky Script (
@GeekyScript) is a Computer Science - Educational Videos Creator 🎉
You can support us by buying a coffee ☕️ here -
www.buymeacoffee.com/geekyscript
✻ I really hope you find this video useful. ♥
✻ Please click on the CC button to read the subtitles of this video.
Now how to solve this issue? We can solve this using these 6 easy steps...
Step 1: Rename the folder mysql/data to mysql/data_old (you can use any name)
Step 2: Create a new folder mysql/data
Step 3: Copy the content that resides in mysql/backup to the new mysql/data folder
Step 4: 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)
Step 5: Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Step 6: Start MySQL from the XAMPP control panel
That's all... And there you go! Your problem got Solved!!
-------- More videos related to Xampp and WordPress ---------
How to Install XAMPP Server on Windows 10 [ 2021 Update ] Step by Step Installation guide
• How to Install XAMPP S...
How to Install WordPress in Xampp (Localhost) [ 2021 Update ] Step by Step Guide Xampp + WordPress
• How to Install WordPre...
The instructions in this video tutorial can be applied to laptops, desktops, computers, and tablets that run Windows 10 operating systems like Windows 10 Home, Windows 10 Professional, Windows 10 Enterprise, and Windows 10 Education. This tutorial will work on all hardware manufacturers, like Dell, HP, Acer, Asus, Toshiba, Lenovo, and Samsung.
#Xampp #MySQL #MySqlShutdownUnexpectely #PHP #Apache
Topics addressed in this tutorial:
How To Fix MySql Shutdown Unexpectedly
MySql not opening in Xampp
Xampp MySQL error
Error: Mysql shutdown unexpectedly
---------------------------------------------------------------------------
Laptop I use:
amzn.to/4937mKs
amzn.to/3HJGXp5
Recommended Laptops (35k Range):
amzn.to/3OqfNqL
amzn.to/3OrvHRZ
amzn.to/3SLK6uX
Laptops 50k Range:
amzn.to/3ujvWHW
amzn.to/3UrW6CL
amzn.to/3SKlJh7
Rode Wireless Mike:
amzn.to/4899rTH
amzn.to/3wd7nwE
Windows 11 Pro 64-Bit: amzn.to/49cEpvk
Windows 10 Pro 64-Bit: amzn.to/3SIxOn0
Quick Heal Antivirus: amzn.to/49gnsAJ
McAfee Antivirus: amzn.to/48ZoHUp
---------------------------------------------------------------------------
MY RELATED VIDEOS:
✻ All about Android Studio: • How to install Android...
✻ All about PostgreSQL: • How to Install Postgre...
✻ All about MongoDB: • How to install MongoDB...
✻ All about MySQL: • How to Install MySQL o...
✻ All about WordPress: • How to Install WordPre...
✻ All about Java Spring: • Spring Framework | Spr...
✻ All about Maven: • Maven project in NetBe...
✻ All about eBook: • How to Create an Ebook...
✻ All about React: • How to Install React o...
✻ All about NextJS: • How to Install Next.js...
✻ All about Angular: • How to Install Angular...
✻ All about Microsoft SQL Server: • How to Install Microso...
✻ All about Wamp: • How to Install WAMP Se...
✻ All about Visual Studio: • How to Install Microso...
---------------------------------------------------------------------------
THANK YOU so much for watching!
Please make sure to LIKE and SHARE the video and SUBSCRIBE to the channel for more such videos :)
---------------------------------------------------------------------------
CONNECT WITH ME ON:
✻ Website: geekyscript.com/
✻ Instagram: / geekyscript
✻ LinkedIn: / geekyscript
✻ Twitter: / geekyscript
✻ Email: geekyscript@outlook.com
✻ KZread channel: / geekyscript
---------------------------------------------------------------------------
Song: Jarico - Island
Music promoted by #BackgroundMusicWithoutLimitations
Watch: • Free Background Music ...
Free Download: bit.ly/3n3snwj
---------------------------------------------------------------------------
Пікірлер: 3 500
Did this tutorial help you to resolve this MySql Shutdown Unexpectedly error in XAMPP SERVER? Comment Now!! and Let me know your opinion... And Please SUBSCRIBE for more! Also, you can Support my work through KZread Thanks!
@ayushranjanrout9758
3 жыл бұрын
yes you are right
@asheqarf3339
3 жыл бұрын
dude i m high and I like you
@somalibrothers7689
3 жыл бұрын
I'm having this problem I did what you have done but still I have that problem I need some help ? 🙋♂️ plz
@GeekyScript
3 жыл бұрын
@@somalibrothers7689 have u installed any other MySQL software? like SQL developer? or workbench..? this may also happen due to the MySQL port conflict..
@somalibrothers7689
3 жыл бұрын
Yes I'm using Xampp for mysql but just I solved the problem thanks for your guidance
it still shows the same thing
Dude! You just saved my life! My mysql stopped working out of nowhere! After hours trying to find a solution, your video was the only one that solved my problem. I wish you the best.
@GeekyScript
2 жыл бұрын
Glad it helped! All the best. :)
@samirkhan7910
Жыл бұрын
@@GeekyScript Same Sir ❤❤❤❤❤Thank you Sir
@sltube2521
2 ай бұрын
Yes you are right ❤
@sltube2521
2 ай бұрын
@@GeekyScript Thank you may the god bless you with skills and more knowledge ❤ thank you my man thank you ❤
@GeekyScript
2 ай бұрын
@@sltube2521 God Bless you too!! Also, watch Complete ECommerce tutorial ⏩ kzread.info/dash/bejne/aWp5lLOmmsu4pLQ.html and WordPress Tutorial Playlist ⏩ kzread.info/dash/bejne/o6hmpLOtZ9i2ktY.html
What about the mysql folder in the old data folder, are we supposed to copy that over, too? So it replaces the mysql folder that spontaneously was generated in the new data folder?
And there is a folder called test in the old data folder. Do we copy that over to the new data folder, or not?
Thanks a lot. You are very precise and straight to the point. God bless you more!
I can't believe it did so well! Thanks for saving me this day, very appreciated!
@GeekyScript
2 жыл бұрын
You're welcome!
Thankyou million times you solved my problem. Your videos are recorded in a perfect way and no wastage of time. Love you
@GeekyScript
Жыл бұрын
You are most welcome!! Pls do subscribe! :)
God Bless You!!! I was trying to start Wordpress with Xmapp and was getting the SQL crash messages. I tried everything including disabling my firewall to no avail. Found your video, follow the instructions, and now everything is working fine. Thanks for this excellent video.
@GeekyScript
Жыл бұрын
All the best for the future :) God Bless You too!
This one is exceptionally better than other tutorials for the same problem.
@GeekyScript
3 жыл бұрын
thanks and most welcome :)
@Marlon_42
Жыл бұрын
Agree
You're a life saver dude. Hats off. Concrete Information 👍👍👍👍
Man, I don't even have words to thank you enough. You are the savior of a student who was stuck on a last-minute deadline. TYSM
@GeekyScript
2 ай бұрын
You're very welcome!! ❤ Also, watch Complete ECommerce tutorial ⏩ kzread.info/dash/bejne/aWp5lLOmmsu4pLQ.html and WordPress Tutorial Playlist ⏩ kzread.info/dash/bejne/o6hmpLOtZ9i2ktY.html
Hey, i did this and everytime i try to go to wordpress with localhost, it comes to the installation page. what do i do?
Thankyouuu so muchhh cant stress how much this has helped me! Saved my internship work. God bless you!!
@GeekyScript
3 жыл бұрын
Glad it helped! Stay connected :) God bless you!!
Thank you soooo much brother. You really made my day.. I was so worried about my data You have got a subscriber 💖
@GeekyScript
2 жыл бұрын
Most welcome 😊
I don't have wordpress folder so i copied just mysql folder and did everything u have done but it's still not working. Can u help me please ?
@dynamoff6807
4 ай бұрын
Same
sir, i still had one problem..my sql was succesfull running but mywordpress was ask for installed, but when i did the wordpress already exist..help
Thank you so much. I'm not a native english speaker, but you explain everything just right that even a foreing can understand. Thank
@GeekyScript
2 жыл бұрын
Welcome 😊 wish you all the very best for the future ✌️
Thanks a lot mate!! :) Really helped me out with the problem! Keep up the good work! Thumbs up! :)
@GeekyScript
2 жыл бұрын
Glad it helped!
can we delete that data old file after making new data file...?? and one more thing is that what's the reason behind this error??
should we delete data_old after the mysql starts working?
Thanks to you this error has been solved. I have just started learning MySql and was having trouble with this error.
@GeekyScript
2 жыл бұрын
Anytime 😊all the best for future learnings ✌️
Thanks a lot, Bro. It really helped me a lot to fix this issue and saved lots of time. Hats Off to you.
@GeekyScript
2 жыл бұрын
Glad it helped
brother but while opening the tables in the database I created,it is showing the error that the table doesnt exist in the engine. plz help!
i have done this weeks ago, but it again have started showing same problem, how ca i solve this
Thank you so much sir
@GeekyScript
3 жыл бұрын
Welcome 😊 stay connected 👍😊
@64_harita72
2 жыл бұрын
tried same this steps but not worked
@trojanhorse3470
2 жыл бұрын
@@64_harita72 Me too
@Urvansh649
2 жыл бұрын
@@64_harita72 ya same issue
Thank you so much sir🥺❤️❤️... For a moment i thought i lost all my data of my project... but your tutorial saved it😁
@GeekyScript
2 жыл бұрын
welcome
@kiranshrimangale5313
2 жыл бұрын
Same 😁
This guy deserves an award 🏆 ...!!! Thank you so much!
@GeekyScript
Жыл бұрын
actually developers of xampp deserved this.. because they have provided that backup folder.. :) by the way welcome.. and all the best :)
Thank you so much, sir. At first, it doesn't work, then I try to not copy the "mysql" folder into the new data folder. Finally, it works
@GeekyScript
Жыл бұрын
Glad it helped
You helped me a lot!! I was supossed to do a homework about phpmyadmin but mysql didn´t work, thanks a lot. 🤓🤓
@GeekyScript
2 жыл бұрын
Happy to help 😊 all the best ✌️👍
Extremely helpful! I tried watching other videos to solve the problem, yours is the only one that explained the solution and that actually worked - thank you!
omg, thank you so much! i thought I would have to redo a database for a server on a game, but you saved it! great video, keep it up 😁👍
@GeekyScript
Жыл бұрын
Glad I could help! Pls do Subscribe also :)
A video that didn't work for me and even ended up corrupting my files which meant I lost my entire SQL. SUPER THANK YOU CHAMPION your video is probably no longer relevant...
Este tutorial es el mejor que encontraran funciona 100% recomendado ♥
@GeekyScript
2 жыл бұрын
Muy bienvenido amigo :) ♥
@gustavoreyes7192
2 жыл бұрын
@@GeekyScript una pregunta bro que pasa si de nuevo despues de arreglar el problema me aparece de nuevo el mismo incoveniente de que no ejecuta mysql porque yo hice los pasos y me funciono bien unas semanas despues de nuevo el mismo problema que hago ayuda porfas :c
Great video. I solved my problem in a very easy way following these instructions. Thx
@GeekyScript
2 жыл бұрын
Glad it helped
I have tried to restore my databases by coping only the databases from the corrupted localserver (wamp) to new installed one and when I try to access them either via code and phpmyadmin, I was denied access and now after I have watched ur video where u said copy and replace [ibdata1] file, i did it and I was granted access to all my databases. In short, u saved my life and energy, u are the best kip up the good work.
sir in data_old folder ,only mysql folder is present not wordpress what i do sir
I've been struggling with this error for 2 days and every other video was about changing the port which i already had done but the same error. Thank you so much for solving my problem through this video.
@GeekyScript
3 жыл бұрын
Glad I could help.. all the best for the future.. stay connected
It solved my problem, total life saver. Thank you.
@GeekyScript
3 жыл бұрын
Happy to help 😊 stay connected 👍😊
hi there , I tried your solution but the pages keep loading indefinitely and never open up , even phpmyadmin is not loading up , what to do? Sql status is shown as running in xampp
You literally saved my life Geeky Script! God bless you through your journey! ❤❤
@GeekyScript
Жыл бұрын
Glad I could help!
Man I just can't thank you enough, You are a life saver 🔥♥
@GeekyScript
Жыл бұрын
Happy to help! All the best :)
Not resolved. Even after clicking on start in front of MySQL, the port number isn't showing.
@KevinArikkatt
4 ай бұрын
how did you solve it?
@pixel__lord
4 ай бұрын
any idea?@@KevinArikkatt
@KevinArikkatt
4 ай бұрын
@@pixel__lord yup I fixed it by removing it from running tasks and again opening it in that application
@nuruljanah9621
Ай бұрын
Click on the config >my.ini> change the port number under [mysqld] from 3306 to 3307. That's all.
i dont have a backup file what should i do ?
thank you very much sir, i have a project presentation in few days, my sql unexpectedly stopped. i was panicking so much. you just saved me.
@GeekyScript
Жыл бұрын
Glad that it helped! Welcome :)
You SAVED MY DAY! God bless!
@GeekyScript
3 жыл бұрын
Most welcome 😊 God bless you too 😇🙏
Thank you so much man, you Save me ...it is 100% working
@GeekyScript
3 жыл бұрын
Most welcome 😊 stay connected 👍😊
but in future will be again this error so what will be do solve this error again?
Muchísimas gracias, un vídeo genial. 👍
Woww...amazing...i solved my problem by this important tutorial 😍😍
@GeekyScript
2 жыл бұрын
Glad it helped
Hello sir, if i fixed means my old data get error how can I fix without troubling my old data
It did not resolve the issue
@gandalabalaji6674
2 ай бұрын
Just go to task bar and end all tasks related to MySQL that's it
@FATMAHASAN-gz6dk
2 ай бұрын
@@gandalabalaji6674thanks very mach
@FATMAHASAN-gz6dk
2 ай бұрын
@@gandalabalaji6674Thanks you very mach
@user-ic9sq6qn4s
2 ай бұрын
@@gandalabalaji6674 it also did not resolve the issue. Now what to do ?
@anawonka
2 ай бұрын
Thanks u so kuch end task mysql stuff fixed my problem omg thanks@gandalabalaji6674
still happening same problem
But after this mysql started but localhost phpmyadmin didn't start how to fix this?
i am facing this problem after I have installed mysql + mysql workbench . will this procedure work on xammp as you have told , as we know port 3306 is already occupied by mysql workbench
@GeekyScript
10 ай бұрын
yeah.. u cant have 2 mysqls on same system which use same port.
I'm still getting this error
@GeekyScript
3 жыл бұрын
What is the issue you are getting?
@shanmukhbhutada
3 жыл бұрын
@@GeekyScript it's showing same error I followed whole procedure as you said.
@GeekyScript
3 жыл бұрын
@@shanmukhbhutada do u have installed mysql in ur system earlier?
@shanmukhbhutada
3 жыл бұрын
@@GeekyScript yes MySQL full thing
@GeekyScript
3 жыл бұрын
@@shanmukhbhutada In that case u need to either install mysql, or change port number for mysql server in xampp
7 minutes spent worth it all love you for the explanation rhank you so so much
Thank you very much! MySQL stopped in the middle of Drupal installation. This worked!!!
@GeekyScript
Жыл бұрын
Glad it helped!
Hey in xampp folder SQL server get started but in workbench it is still showing connection lost
@GeekyScript
Ай бұрын
This video should be helping you: kzread.info/dash/bejne/eWGqldGfkrPWfbA.html
my xmapp stoop after few days whats the parmanent solution?
It really worked for me! Thank you so much for spreading such content with us😊😊😊
@GeekyScript
Жыл бұрын
Most Welcome! :)
it didnt worked for me..could u suggest any other method
@Karansingh-vf7ei
Жыл бұрын
mere liye chi
I still get the same error. Can you help me? I watched your video from start to finish as you asked.
I've seen alot of tutorials regarding this problem whenever I faced this issue but none of them worked for me, You made my day bro. I rarely subscribe youtube channels but you know what you got me.
Sir ye error baar baar aara hai means kuch din shai chlta hai then error sir please reply
after these steps mysql server started working for me, but now databases are not opening it is showing "doesn't exist in engine" error
I did every step you shown by you, it started working but after sometime it showed same error. Can someone help me out ASAP.
The xampp problem was solved but now I can't log in to the WordPress dashboard please help with this problem
Thank you so much for sharing this video. It has been very helpful☺. This video is being watched for the second time as the same error has occurred again after a year 😅
@GeekyScript
Жыл бұрын
☺ Glad it was helpful!
Thanks Sir , It works . But In case if I don't found backup folder in xampp installation , Is it okey to bring folder backup from other installation of Xamppp and just put it ?
@GeekyScript
Жыл бұрын
Yes, you can.. as long as that backup folder is pristine
Wordpress folder is not present in my data_old...help me
This method hasn't solved my issue, what should I do?
You saved my life .....I had all my project database created in my old xampp i didn't wanted to remove and reinstall it ....this solved my issue ❤❤❤
@GeekyScript
2 ай бұрын
Glad it helped! Also, watch Complete ECommerce tutorial ⏩ kzread.info/dash/bejne/aWp5lLOmmsu4pLQ.html and WordPress Tutorial Playlist ⏩ kzread.info/dash/bejne/o6hmpLOtZ9i2ktY.html
i tried all methods then also not working for me someone please help !!
somehow i deleted my original ibdata1 of 77k kb and now only7 the 12k kb ibdata1 is there and mysql is not starting 😭😭😭 in error log it is showing that theres no error and it is running but actually it is not as shown in the Homepage of Xampp that Activating and Error , so check Error log but Erro log telling no error. WTFKKk is happening 😭😭😭😭
WordPress folder is not present there what should we do
Thank you, Sir. This video guidance is GREAT! It has resolved the "MySql Shutdown Unexpectedly error" issue in the XAMPP of my son's laptop. He can now go back to the assigned project tasks of his supervisor. God bless, Sir.
@GeekyScript
Жыл бұрын
Glad it helped! Same process actually.. just go to htdocs folder of xampp..
Sir I am facing this error problem again and again.After some time this error comes again.How to solve it please reply
If anyone having this type of error after the video then you simply have to delete your previous mysql which you have downloaded i am also facing the same problem now it is been solved. Thanks you for the nice video..
can i delete data old
Clear and helpful video. Thanks for saving my day!!!
@GeekyScript
Жыл бұрын
Glad it helped!
it did not working for me. File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. ( although i did as you ) :(
Thanks man! Your tutorial is really helpful!
@GeekyScript
Жыл бұрын
Glad it helped!
THANK YOU sql stopped working one day before review and was freaking out, fixed it
@GeekyScript
Жыл бұрын
Glad I could help
Thanks for tutorial. I would have lost all my work if it weren't for you. This video is very efficient.
@GeekyScript
Жыл бұрын
Glad it helped
It has solved the error but it keeps coming on restarting server. How to fix that??
i tried so many things and I haven't expexted that this works but it did. ty so much
Thank you so much!! but can i delete the data old folder completely??
@GeekyScript
Жыл бұрын
Yes you can!
this happen to me everytime i try to open the port from a different wifi. thank you again man
sir ur screen is not clear so pls tll me when we make a new directory copy 1st data and after that where I go and what type data we copied again mysql is not start yet so pls reply as soon as possible
on mysql folder, data folder is missing
Didn't work. I've tried everything I can find online. Is there no way to track down the error from logs? My error logs show no errors. It just shuts down. That's why you should never rely on third party software. You can use 3rd party software for the little things. I don't know what to do. I have no idea why it's not working. I've tried everything.
There is no WordPress file is present as a directory here🙂what should i do?
thanks bro for guiding me . If I don't saw your videos I wanna lose my whole project
@GeekyScript
Жыл бұрын
Glad to hear that.. All the best for ur project :)
@AniketGamerzYt
Жыл бұрын
@@GeekyScript thanks 🙏
just followed this and thank you it worked, but tell me, how often do you have to do it? I installed this, then it fell over, followed your fix it worked, but will it behave moving forward?
@GeekyScript
Жыл бұрын
update xampp
@alastairleith249
Жыл бұрын
@@GeekyScript it is the latest version, not long installed it.
my apache is not running what should I do? the mysql is ok
Congratulations, you were the only one that worked and didn't delete my site
Really Very very thank for this video. Wasted 2 days how to solve this issue and it took 10 min after watching this video.
@GeekyScript
Жыл бұрын
Most Welcome! :)
You just save my life!!, I thought I will lost my database. Thank you sir, I appreciate that!!
@GeekyScript
Жыл бұрын
Welcome!
Thanks @geekyscript , I searched everywhere and i have wasted my one week to solve this issue but nothing helped. By luck i found very video helpful and my problem has solved.
@GeekyScript
Жыл бұрын
Most Welcome! :)