How to solve the problem that the MySQL service in XAMPP shuts down automatically after being started for a while?

in your XAMPPMySQLDid the service automatically shut down?This article provides solutions to help you solve this problem.

Want to test on local computerWordPress website, test and modify the WordPress theme code, and install XAMPP Win64softwareAfter that, and did not encounter any problems,MySQLStarted in the control panel and everything worked as usual.

However, when I restarted the computer, Apache was still working, but MySQL would not start!

Then, try to reinstall XAMPP, but MySQL can't work as usual, and even once the MySQL service is started, it will automatically shut down soon.

The MySQL service in XAMPP is automatically closed after a while after it is started

The following is part of the error log of XAMPP's MySQL service▼

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

How to solve the problem that the MySQL service in XAMPP shuts down automatically after being started for a while?

Open a shell from the control panel and start XAMPP with the following command ▼

mysqld --console --skip-grant-tables --skip-external-locking

Open another shell from the control panel and use the following commands to repair the database ▼

mysqlcheck -r --databases mysql --use-frm

• Stop XAMPP, close the shell, and restart XAMPP.