![]() It’s recommended to make a backup of the data folder (renamed to old-data) before proceeding. Note that ibdata1 should not be deleted, as this contains important information about your databases. The folder names for your databases are also important. The most important file in the “data” folder is ibdata1. Here, you need to look at two folders: data and backup. This will open the file explorer in the MySQL folder. You can do this by clicking on “config” and then “browse”. To solve this issue, you need to go to the MySQL folder. In this case, we could look at the logs and other information to find out what happened. One possible solution is to try to restore a previous backup of the data folder or reconfigure the MySQL server. If MySQL is not starting, it is possible that something has damaged the configuration files or the data folder. Case 2: Something has damaged and prevents MySQL from starting You can access services from the XAMPP Control Panel. You could also search for the service in services and stop it if it is using IIS in addition to XAMPP, for example. In the previous image, we can see that the PID (process id) is 6956, so we could stop that process in order to use the application that is using our port, if that were the case.Īdditionally, we could also change the port that MySQL uses to another port in Config > Service and Port Settings > MySQL. If the port is being used, it will return a result, if not, it won’t (CMD – Terminal) netstat -ano -p tcp |find "3306" ![]() Usually, our main port is 3306, which we can change if it is being used as a second solution if this is the case. ![]() ![]() Initially, I thought the port was the problem, but on second thought, the program should have notified that the port was being used.įirst, to know which port my MySQL (MariaDB) is trying to use, you can do this within XAMPP in Config > Service and Port Settings > MySQL. In this section, we will see how to fix some of the MySQL problems in XAMPP. Unfortunately, I did not take a screenshot of my error, but the error was very similar to the one presented below. In these last few days, I have encountered this exact error after updating my Windows, before everything was working correctly. Author: Admin/Publisher |finished | checked XAMPP – Error: MySQL shutdown unexpectedly ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |