Ошибка xampp не запускается mysql

Почему то перестал работать mySQL, сегодня же запускал все было хорошо, может быть кто-нибудь сталкивался? что можно сделать?

18:11:56  [mysql] 	Error: MySQL shutdown unexpectedly.
18:11:56  [mysql] 	This may be due to a blocked port, missing dependencies, 
18:11:56  [mysql] 	improper privileges, a crash, or a shutdown by another method.
18:11:56  [mysql] 	Press the Logs button to view error logs and check
18:11:56  [mysql] 	the Windows Event Viewer for more clues
18:11:56  [mysql] 	If you need more help, copy and post this
18:11:56  [mysql] 	entire log window on the forums

InnoDB: using atomic writes.
2020-04-03 17:41:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-03 17:41:35 0 [Note] InnoDB: Uses event mutexes
2020-04-03 17:41:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-03 17:41:35 0 [Note] InnoDB: Number of pools: 1
2020-04-03 17:41:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-03 17:41:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-03 17:41:35 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-03 17:41:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-03 17:41:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-03 17:41:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-03 17:41:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-03 17:41:35 0 [Note] InnoDB: 10.4.11 started; log sequence number 10282705; transaction id 18356
2020-04-03 17:41:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-03 17:41:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-03 17:41:35 0 [Note] Server socket created on IP: '::'.

Google Brings me here. The favourite answers don’t help me.
I’ve now solved it, so maybe this will help someone else.
Problem: after UPDATE of XAMPP to a new version I get the message «MySQL WILL NOT start without the configured ports free!».

However, I only have 1 instance of mysqld running.

It seems that the control panel is not as clever as it looks. As far as I can tell, the single instance of mysqld is the new one i’ve just updated to, but running as a ‘service’. The control panel then tries to start it, and instead of realising its already running, It assumes its another service and reports the error.

Probable cause: The uninstaller failed to remove the autostart property from the mysql service, so the new instal picked it up.

Solution:
open the Xammpp Control Panel and click on the Services Button on the right. This will open the services control panel.
Look for mysqld in the list of running processes, right-click it to get the properties and change the startup type to «Manual».
you might as well do the same for Apache2 while you’re here.
Apply changes and Close the services control panel.

Now click the Config Button on xampp control panel, uncheck The Mysql (and Apache) Autostart features.

Reboot the machine.
You should now be able to start / stop Mysql & Apache without any error messages.
If this works, use the Xampp Control panel as usual to start/stop add service or add autostart as normal.
No need to mess with any ports or config files.

If you use a local development environment, you may run into problems that are similar to those on a live server. In some cases, your WordPress website may be unable to connect with its database because MySQL isn’t running or it shut down unexpectedly.

Depending on which local environment you use, the process of troubleshooting your MySQL database might vary a bit. With XAMPP, the process is remarkably straightforward since you get access to a control panel instead of having to rely on the command line only.

In this article, we’ll explain what XAMPP is and what the “MySQL shutdown unexpectedly” error means. Then we’ll walk you through three methods you can use to fix it. Let’s get to it!

An Introduction to XAMPP

XAMPP is a free, PHP development environment that you can use for Windows, macOS, or Linux. It is a collection of software that enables you to host websites locally by mimicking the functions of a live server:

Using XAMPP, you can install all the software you need to run WordPress locally using a single bundle, rather than setting up each element individually. Development environments differ in what software they bundle.

With XAMPP, the components that you get include:

• Apache: This is arguably the most popular web server software in the world, and it enables you to host sites.
• MariaDB: This open-source database software enables you to manage databases.
• PHP: WordPress is built on PHP, which means you need a PHP install to run the Content Management System (CMS).
• Perl: Although WordPress doesn’t use the Perl programming language, it comes as part of the XAMPP stack by default.

On top of setting up the software you need to run WordPress, XAMPP provides you with a simple control panel:

This enables you to access logs for each of XAMPP’s components. It includes an overview log that shows you everything that’s happening in the background of your environment.

However, using a local development distribution doesn’t mean your server isn’t susceptible to errors. In some cases, the software components may malfunction, such as with the XAMPP error “MySQL shutdown unexpectedly”.

What Is the XAMPP Error “MySQL Shutdown Unexpectedly”?

As the name of the error implies, this is the message you’ll see if the MySQL software on your environment shuts down or ceases to function unexpectedly:

We say “unexpectedly”, because you can manually shut down the MySQL database software at any point. That also happens when you restart your server.

However, when the software is shut down, your website won’t be able to connect to its database. In other words, WordPress won’t work.

As you can see in the above image, XAMPP provides you with advice on troubleshooting the “MySQL shutdown unexpectedly error” right within its events log. In the next section, we’ll go into more detail on the various ways you can use to fix this issue.

How to Fix the XAMPP Error “MySQL Shutdown Unexpectedly” (3 Methods)?

Typically, fixing the XAMPP error “MySQL shutdown unexpectedly” is quick and easy. Below, we’ll walk you through three fixes, starting with the simplest.

1. Run XAMPP Using Administrator Privileges

Often, XAMPP produces errors when you don’t run the software using administrator privileges. This is because its components may not be able to function or configure properly at lower permission levels.

If you’re unsure whether that’s the case with your setup, we recommend that you close XAMPP altogether, and then restart the environment as an administrator. To do so in Windows, find the folder where you installed XAMPP and locate the xampp-control file. Next, right-click on that file and select Run as administrator:

If you’re a macOS user, you can right-click on the folder, and then select Get Info. In the pop-up window that opens, navigate to the Sharing & Permissions section, click on the padlock icon, and enter your administrator password. Change the Read & Write permission settings to Everyone.

Once XAMPP is up and each of its components is running, MySQL should function correctly. That means your database will be accessible.

2. Restore Your Database Backup

If restarting XAMPP with administrator privileges doesn’t solve the problem with your database, the next step is to restore its backup. XAMPP automatically creates backups for your environment’s software, which you can access within the folder where you installed it.

By default, your XAMPP MySQL backup files should be under Local Disk > XAMPP > MySQL. Inside that directory, you’ll see several folders, two of which are called data and backup:

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

You can make a backup by clicking on the Stop button to the right of the MySQL option on the main menu:

Once you stop MySQL, return to XAMPP’s MySQL folder and follow these steps to restore the MySQL backup:

1. Make a copy of the data folder.
2. Rename this new folder copy to something like data-old. This will be your backup.
3. Copy the contents of the backup folder into the data folder.

That’s it! To play it safe, though, we strongly recommend that you keep the data-old folder around until you make sure everything is working properly.

At this stage, you can return to the XAMPP control panel to restart MySQL, which should be running correctly now.

3. Change Your MySQL Port

One of the most common causes of the XAMPP error “MySQL shutdown unexpectedly” is another software using the port assigned to MySQL. By default, it tends to be 3306. To be certain, you can select the Netstat module from XAMPP’s control panel, right above the Shell tool:

Netstat is a command line tool that can show you active connections on your network, including which ports they’re using. Once you initialize Netstat, you’ll be able to see what port each tool in your stack is using, including MySQL.

If a conflict with that port caused the shutdown, restoring a backup or running MySQL with administrator privileges won’t make a difference. The only way to solve this issue is to change the port that MySQL uses. Thanks to Netstat, you can see what that port is and which other ones are in use.

To do so, go ahead and stop the service, using the same process we showed you in the last section. Next, click on the Config button next to MySQLon XAMPP’s main menu, and then select the my.ini option:

The my.ini file contains the MySQL configuration settings. After you click on it, XAMPP will open the file using your default text editor. Once you’re in, look for the line that reads Port, which specifies the port number that MySQL uses.

Here, you can change that port number to another option that you know other programs aren’t using. In most cases, we recommend using 3307, which should be available. Save your changes and close the my.ini file.

You can then use the XAMPP control panel to restart MySQL. Hopefully, your database is now working as it should. If for some reason, XAMPP can’t connect to your database using the new port that you set, it will let you know through the control panel’s log. In that case, you might try using a different port instead.

Summary

If you use XAMPP to run WordPress locally, you may encounter the occasional error with your server’s configuration. One of the most common issues is MySQL shutting down unexpectedly.

The good news is that, if this does happen, there are three methods you can use to troubleshoot the issue:

1. Run XAMPP using administrator privileges.
2. Restore your database backup.
3. Change your MySQL port.

If you enjoyed this XAMPP tutorial, be sure to check out DevKinsta as well. DevKinsta is our free local development tool that lets you quickly spin up WordPress sites with customizable PHP settings, HTTPS support, built-in email and database management, and more. DevKinsta also features full integration with MyKinsta, but you don’t have to be a Kinsta customer to integrate DevKinsta into your workflow.

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.

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.

1. Launch XAMPP as administrator
2. Repair MySQL Database
3. Modify the my.ini file
4. Delete all the files inside the Data folder
5. Rename the aria_log_control file
6. Stop all the SQL services and start them again
7. Copy the files from the Backup folder to the Data folder
8. Delete the INFO file(s) from the Data folder
9. Rename the Data folder and copy the ibdata1 file to the Data folder
10. 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:

1. Click on Windows Search and type XAMPP.
2. Right-click on XAMPP and select Run as Administrator.
3. 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:

C:\xampp\mysql\bin

1. Open the File Explorer.
2. Copy the above path and paste it into the address bar of File Explorer. After that hit Enter.
3. Now, scroll down and locate the my.ini file.
4. 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.

1. Click on Windows Search and type XAMPP.
2. Right-click on XAMPP from the search results and select Run as Administrator.
3. Click Yes in the UAC prompt. This will open the XAMPP Control panel.
4. 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:

C:\xampp\mysql\data

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:

C:\xampp\mysql\bin

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:

C:\xampp\mysql\data

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:

1. Press the Win + R keys. This will launch the Run command box.
2. Type services.msc and click OK. The Service Management window will appear.
3. In the Services app, scroll down and locate the SQL services. You may find more than one SQL service on your computer.
4. Stop all the SQL services. For this, right-click on SQL service and select Stop.
5. 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.

C:\xampp\mysql\backup

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:

C:\xampp\mysql\data

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.

C:\xampp\mysql\data

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.

1. Open the XAMPP folder located on your C drive.
2. Now, open the mysql folder.
3. Rename the data folder to data_old.
4. 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.
5. 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.
6. 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:

C:\xampp\mysql\bin

Hope this helps.

Read next: Apache is not starting from XAMPP Control Panel in Windows 11/10.