[Resolved] XAMPP Error: MySQL Shutdown Unexpectedly | Fail to start MySQL service in XAMPP

Generally, when we start MySQL service from XAMPP's control panel, it utilizes default port number 3306. But sometimes it may happen that, some process already uses the MY SQL default port. In such case, the MySQL service fails to start, and XAMPP throws an error stating, that MySQL has shut down unexpectedly. We can either close the process that is using MySQL's port or we can change the default port for MySQL.
Sometimes, this error may arise if for some reason the MySQL data files get corrupted. We can fix this issue by replacing the corrupted data files, in the path mysql/data, with proper files.
This video covers a step-by-step guide to solving this issue. We have covered how to look for a process using MySQL's port number and end that process. We have also covered how to assign a new port number to the MySQL service and also how to replace MySQL's corrupted data files with valid files.
The process is simple. I hope this video helps you to resolve the MySQL service error during its startup.
Thank You.
The written guide to the process of replacing MySQL's data files with valid files is given below (this is the 3rd method explained in the video):
Step 1: Navigate to your XAMPP MySQL directory (C:\xampp\mysql).
Step 2: Create a new folder called DIR_BACKUP.
Step 3: Copy the folders, C:\xampp\mysql\backup and C:\xampp\mysql\data into C:\xampp\mysql\DIR_BACKUP.
Step 4: Copy the contents of C:\xampp\mysql\backup and paste them into C:\xampp\mysql\data and overwrite all the files.
Step 5: Finally copy the ibdata1 file from C:\xampp\mysql\DIR_BACKUP\data and paste it into C:\xampp\mysql\data and overwrite the file.

[@MrIanspeed]

Thank you sooooooooooo much, the replacing of data files worked for me!! Thank you for taking the time to put this video up 👌👍😊😊

[@amanornarhandrews]

This really helped Very good video 😍

[@JoanaPinto-b8h]

Thank you very much, it helped me a lot. 😊🙏

[@HaifengZhu-pn3uq]

It works for me, your solution is 100% perfect

[@HaifengZhu-pn3uq]

after this, phpmyadin cannot open, I got the error "This site can’t be reachedlocalhost refused to connect."

[@tinytips4823]

There are some trouble shooting steps one by one you can try: 1. Flush the DNS: In command prompt type 'ipconfig /flushdns' then press enter. 2. You can try deleting localhost from your browser. in your browser type 'chrome://net-internals/#hsts' and press enter. No matter whatever browser you use, the name will get updated. Then under 'Delete domain security policies', type localhost and press delete. Restart your browser for changes to take effect (important). 3. You can try turning off the windows defender firewall and check if the issue persists or not. 4. Change the default port number in httpd.conf file. You may see the process in one of my videos with the title "[Solution] Apache and MySQL service startup error in XAMPP". Look at the initial part of the video, dealing with httpd.conf file

[@bushraw66]

I get a different PID number every time I try to run mysql before it's unexpectedly shut, (although the port number is always the same which is 3306) do I shut off every PID number It shows?

[@tinytips4823]

Better modify the default port number.