Some users are unable to start MySQL in XAMPP. According to them, every time they start MySQL in XAMPP, they receive an error message that says “Error: MySQL shutdown unexpectedly.” The most common cause of this problem is the corrupted database files of XAMPP. If you are experiencing such an issue with MySQL, the suggestions provided in this post may help you fix the problem.
Why does MySQL shutdown unexpectedly?
It is necessary to stop MySQL before exiting XAMPP. If you exit XAMPP without stopping MySQL, it may corrupt the MySQL data files. Due to this, you may experience several problems with MySQL, like the shutting down of MySQL unexpectedly. If you are experiencing such a problem, it might be possible that the MySQL data files on your system are corrupted. We have described some troubleshooting methods that may help you get rid of this problem.
Error: MySQL shutdown unexpectedly
Try the following solutions to fix the issue. Before you proceed, we recommend you create a backup of the XAMPP folder. For this, copy the XAMPP folder and paste it into another partition of your hard drive or your external hard drive.
- Launch XAMPP as administrator
- Repair MySQL Database
- Modify the my.ini file
- Delete all the files inside the Data folder
- Rename the aria_log_control file
- Stop all the SQL services and start them again
- Copy the files from the Backup folder to the Data folder
- Delete the INFO file(s) from the Data folder
- Rename the Data folder and copy the ibdata1 file to the Data folder
- Uninstall and reinstall Xampp
Let’s see all these solutions in detail. Before trying every method written below, make sure that you have closed XAMPP properly.
1] Launch XAMPP as administrator
It is recommended to always launch XAMPP as an administrator to avoid data file corruption. Launch XAMPP as administrator and see if it fixes the problem. If this helps, you will save time on other troubleshooting methods. To launch XAMPP as administrator, follow the steps below:
- Click on Windows Search and type XAMPP.
- Right-click on XAMPP and select Run as Administrator.
- Click Yes if you receive the UAC prompt.
You can also set XAMPP to always run as administrator.
2] Repair MySQL Database
As described above in this article, the main cause of this problem is the corruption in XAMPP data files. If the problem is occurring on your computer due to this issue, repairing the MySQL database can fix the issue. The steps to repair the MySQL database are given below:
Click on Windows Search and type PowerShell. Select Windows PowerShell from the Search Results.
Type the following command and press Enter.
mysqld --console --skip-grant-tables --skip-external-locking
The above command will start the MySQL server without loading the grant tables. When the above command is executed successfully, type the following command and press Enter.
mysqlcheck -r --databases mysql --use-frm
The above command will repair the MySQL database. After the above commands are executed successfully, check if the issue persists.
3] Modify the my.ini file
Changing the port by modifying the my.ini file has fixed the issue for some users. You can also try this. Open the my.ini file and change the port 3306 to something else. By default, the my.ini file is located at the following location:
- Open the File Explorer.
- Copy the above path and paste it into the address bar of File Explorer. After that hit Enter.
- Now, scroll down and locate the my.ini file.
- Once you find it, right-click on it and select “Open with > Notepad.”
If you do not find the my.ini file at the above-mentioned location, you can follow the instructions mentioned below.
- Click on Windows Search and type XAMPP.
- Right-click on XAMPP from the search results and select Run as Administrator.
- Click Yes in the UAC prompt. This will open the XAMPP Control panel.
- Click on the Config button next to MySQL and select my.ini. This will open the my.ini file in your default text editor software.
After opening the my.ini file in Notepad, press the Ctrl + F keys and type 3306. Replace any of the 3306 ports with a different port number. You can enter any random port number, like 3307, 3308, etc. For some users, replacing the 3306 port with 2811 fixed the issue.
Save the my.ini file and close Notepad. Restart your computer and then launch XAMPP. Check if the issue is fixed. If this does not work, revert the changes that you have made in the my.ini file and try the next solution.
4] Delete all the files inside the Data folder
If the above solution did not fix your problem, revert the changes in the my.ini file that you have just made. Now, open the File Explorer and go to the following path:
The above path opens the Data folder directly. Now, delete all the files except the folders. After deleting the files inside the Data folder, go to the following path in File Explorer:
Locate the my.ini file and open it with Notepad. Now, type port=8111 just below port=3306 (as shown in the screenshot above). Press the Ctrl + S keys to save the changes you made in the my.ini file and close Notepad. Now, run XAMPP as administrator and start MySQL. The problem should not occur this time.
5] Rename the aria_log_control file
If the above solution did not fix your problem, Open the XAMPP folder that you copied on your external hard drive or on another hard drive partition and copy all the contents inside it. Now, open the XAMPP on your C drive and paste the copied content there. Replace the files and folders if you will be asked to do so. Now, go to the following path:
Rename aria_log_control to aria_log_control_old and launch XAMPP. Start MySQL and see if this brings any changes. If this does not help, revert the changes and try the next solution.
Read: Best free Xampp Server alternatives for developers.
6] Stop all the SQL services and start them again
Restarting the SQL services has fixed the issue of some users. This method may work for you too. Open the Services app and stop all the SQL services and start them again. The steps to do this are written below:
- Press the Win + R keys. This will launch the Run command box.
services.mscand click OK. The Service Management window will appear.
- In the Services app, scroll down and locate the SQL services. You may find more than one SQL service on your computer.
- Stop all the SQL services. For this, right-click on SQL service and select Stop.
- Now, right-click again on the SQL services and select Start.
After restarting the SQL services, close the Services app and launch XAMPP as administrator. Start MySQL and see if the error occurs again.
7] Copy the files from the Backup folder to the Data folder
Another effective solution to fix this problem is to copy all the data inside the Backup folder and paste it into the Data folder. To do so, first, copy the below path and paste it into the address bar of the File Explorer. After that press Enter.
This will open the Backup folder of XAMPP in your C directory. Now, copy all the data from there and go to the following path:
Paste the copied data there. If you are prompted to replace the files, select Yes. Launch XAMPP as administrator and check if you can start MySQL this time. If not, try the next solution.
8] Delete the INFO file(s) from the Data folder
If the problem still persists, delete the INFO file and check if it helps. The INFO file(s) is/are located at the following location on your C drive.
Whether there is one or more than one INFO file at the above location, you have to delete all of them. After deleting the INFO file(s), launch XAMPP and start MySQL. MySQL should start without giving any error.
If this does not work, copy all the files from the XAMPP folder that you have created as a backup on your external hard drive or on another hard drive partition and paste the copied files inside the XAMPP folder on your C drive. Replace the files and folders if you are asked to do so.
9] Rename the Data folder and copy the ibdata1 file to the Data folder
This solution has helped a lot of users. If the above solutions did not fix your problem, this method should work for you. Rename the Data folder and copy the ibdata1 file to the Data folder. The process to do this is explained below.
- Open the XAMPP folder located on your C drive.
- Now, open the mysql folder.
- Rename the data folder to data_old.
- Copy the backup folder on another partition of your hard drive or on an external hard drive. Now, rename the backup folder located inside the mysql folder on your C drive to data.
- Open the data_old folder and copy all the database folders inside it and the ibdata1 file. Do not copy the mysql, performance_schema, and phpmyadmin folders. Now, open the data folder (which was actually the backup folder earlier) and paste the copied data there. Replace the files if you are asked to do so.
- Launch XAMPP Control Panel and start mysql.
10] Uninstall and reinstall XAMPP
If all the above solutions failed to fix your problem, uninstall and reinstall XAMPP. You can uninstall XAMPP from the Control Panel or from Windows 11/10 Settings. After uninstalling Xampp, download its latest version from the official website of Apache and install it again.
Read: How to increase phpMyAdmin upload size on XAMPP.
What to do if MySQL is not opening in XAMPP?
You may experience problems with XAMPP if you install it in another location instead of its default location. The default location to install XAMPP is c:\xampp. Therefore, if you have installed XAMPP on another location, uninstall it and install it on its default location. If you have installed XAMPP on its default location but still MySQL is not opening or running in XAMPP, open the Services app in Windows 11/10 and stop all SQL services and start them again.
Another effective solution to fix this problem is to change the port 3306 to 3308. To do this, you have to edit the my.ini file, which is located at the following location:
Hope this helps.
Read next: Apache is not starting from XAMPP Control Panel in Windows 11/10.