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

Question

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 😄

Answer 1

🎉 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

Answer 2

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

Answer 3

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😇

Answer 4

You can also use wamp server .

Answer 5

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! 👍

Answer 6

Run Xampp as administrator.
Else you need to reinstall it... BUT before uninstalling, backup the files!
Xampp gives trouble sometimes. 😔

Answer 7

Herbert Olinga after completing sololearn html course

Answer 8

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?