If you're experiencing an issue with XAMPP when attempting to run MySQL on Windows 10 x64 and it shuts down unexpectedly, follow these steps to resolve the issue:
1. Change the name of the "mysql/data" folder to "mysql/data_old".
2. Create a new folder named "mysql/data".
3. Transfer the contents of "mysql/backup" to the newly created "mysql/data" folder.
4. Move all database folders from "mysql/data_old" to "mysql/data", excluding the "mysql", "performance_schema", and "phpmyadmin" folders.
5. Replace the "ibdata1" file in the "mysql/data" folder with the one from "mysql/data_old".
6. Finally, start MySQL from the XAMPP control panel.
Note: XAMPP automatically creates backups, which can be found in the folder where it was installed.
The "MySQL shutdown unexpectedly" error is most often caused by a conflict with another program or a problem with the MySQL configuration. Check if there is any other application already using the same port (usually 3306) that MySQL is configured to run on. Port conflicts can cause MySQL to shut down. You can change the MySQL port in the XAMPP configuration if needed.
26 авг 2024
