Do you find MySQL shutdown unexpectedly in XAMPP? Read this article to know about the methods to fix the issue. At Bobcares, with our MySQL Support, we can handle your MySQL issues.

Fixing MySQL shutdown unexpectedly in XAMPP

The XAMPP error “MySQL shutdown unexpectedly” is typically quick and simple to resolve. In this post, we’ll go over three fixes.

1. Run As Administrator

When XAMPP is not run with administrator rights, it frequently generates errors. This is due to the possibility that its components cannot be configured or function effectively at lesser authorization levels.
In such a case, we need to shut down XAMPP and restart the environment as an administrator. To do this in Windows, locate the xampp-control file in the folder where XAMPP was installed. Next, choose Run as administrator by performing a right-click on that file.

MySQL should operate properly once XAMPP is set up and all of its components are active. As a result, the database will be available.

2. Restoring Database Backup

Environment software receives automatic backups from XAMPP, which we can access in the folder where it was set up. The XAMPP MySQL backup files must be located under Local Disk >> XAMPP >> MySQL by default. We’ll find numerous directories in that directory, including two titled data and backup.

The backup folder contains a single recent copy of MySQL. The data folder includes all of the files that the database uses.

3. Changing MySQL Port

One of the most frequent reasons for the XAMPP issue “MySQL shutdown unexpectedly” is that another program is using the MySQL port. Typically, it is 3306 by default.
Restoring a backup or running MySQL with administrator rights won’t help if a port conflict led to the shutdown. Changing the port that MySQL uses is the only method to resolve this problem.

We can determine what port it is and which others are in use by using Netstat. Then access MySQL’s config file and change the port number.

[Looking for a solution to another query? We are just a click away.]

Conclusion

The article provides some of the common reasons for the “MySQL shutdown unexpectedly in XAMPP” error. We also provide some of the methods from our Tech team to fix it.