Xampp: MySQL shutdown unexpectedly error. [Solved: I reinstalled it] | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 15

Xampp: MySQL shutdown unexpectedly error. [Solved: I reinstalled it]

I am trying to run xampp PHPmyadmin but whenever I start MySQL I get the following error https://drive.google.com/file/d/1-pm4K2CvJE4T8ZM5EDXW-u9Uuaeyebsl/view?usp=drivesdk I have tried methods from youtube and stackoverflow and none of them worked for me. I have tried deleting files, changing port and ending task. I hope you can help me with this, Thanks a lot in advance 😄

9th Sep 2019, 1:37 PM
Ashutosh Agrawal
Ashutosh Agrawal - avatar
8 Answers
+ 11
🎉 Ashutosh Agrawal 🎉 hi, This situation has faced due to various reasons from which first reason specified in the log message which is 1) missing or blocked port that means when you install xampp MySQL, Apache, tomcat all have assigned an port number where they are used so MySQL too required port number which might blocked or occupied by some other server might the individual separate MySQL server or any other server so to remove that error and worked properly change the port number of xampp MySQL by going on xampp folder and select MySQL folder in which configuration and myini file will present search ports in that files and change it to any other port 8008 or 3306 or something else free port and try again the error will resolved If not then again search for Listen or 80,update listen port to 8080 or 8010 and save this will assign some free ports and blocking ports error will get resolved
10th Sep 2019, 6:50 AM
+ 10
2) you have tried that methods then the most possible reason is that your assigned ports are already occupied by some other system files or server or databases which you are using in the port so before changing the ports you should know that change port has free for use if you have installed the separate version of MySQL then delete that version too help to get access to the xampp default MySQL window to be worked properly that is might an reason because of which your xampp not running sql at changing the ports as the problem is resolved by reinstall the xampp then their must be some missing files or installation problem which blocked the xampp to run https://youtu.be/syk4aRewY-Y 3) if that too not working then open task manager and find where MySQL id is running kill that all id and retry above method Always run the xampp in administrator which has give it smooth and fast access https://youtu.be/2kKryOqmpoo https://stackoverflow.com/questions/18022809/xampp-mysql-shutdown-unexpectedly
10th Sep 2019, 6:55 AM
+ 6
GAWEN STEASY I should have waited for your answer before reinstalling xampp😂😂😂😂 Thanks a lot I hope people stumbling on this issue can now easily fix it😇
10th Sep 2019, 9:10 AM
Ashutosh Agrawal
Ashutosh Agrawal - avatar
+ 5
You can also use wamp server .
10th Sep 2019, 4:03 AM
Ayushi Gujarati
Ayushi Gujarati - avatar
+ 3
I saw a note on your logs there, mentioning about the necessity to start the application under administrative account. I have forgotten about the Control Panel mostly, can you tell me what that 'Config' button do in recent version? Also try to search the net for a way to manually install MySQL as service. XAMPP automatically creates one actually, but seems that automatic one cannot start properly, probably due still to that privilege issue (non administrative account). But that was a guess : ) Hope you get it running soon! 👍
9th Sep 2019, 1:58 PM
+ 3
Run Xampp as administrator. Else you need to reinstall it... BUT before uninstalling, backup the files! Xampp gives trouble sometimes. 😔
9th Sep 2019, 2:30 PM
Kartik - avatar
+ 3
Herbert Olinga after completing sololearn html course
10th Sep 2019, 3:16 PM
Ashutosh Agrawal
Ashutosh Agrawal - avatar
Hi folks, newbie here. Just curious, how long did it take for you to confidently say I've mastered html before moving to css & js?
10th Sep 2019, 2:49 PM
Herbert Olinga
Herbert Olinga - avatar