An Interest In:
Web News this Week
- April 2, 2024
- April 1, 2024
- March 31, 2024
- March 30, 2024
- March 29, 2024
- March 28, 2024
- March 27, 2024
How To Fix The XAMPP ERROR on MySQL Shutdown Unexpectedly?
Originally posted @ https://codeanddeploy.com visit and download the sample code: https://codeanddeploy.com/blog/how-to/how-to-fix-the-xampp-error-on-mysql-shutdown-unexpectedly
In this post, if your XAMPP has an error on MySQL shutdown unexpectedly then this is for you. I also experience this issue so I want to share the solution with you in case you experience it.
Sample errors:
Error: MySQL shutdown unexpectedly.
Due to a blocked port
Missing dependencies
Improper privileges
Shutdown by another method
Before doing this we recommend not to delete your files instead do a backup for it in case of unusual results.
Here are the steps below:
- Rename the folder mysql/data to mysql/data_old (you can use any name)
- Create a new folder mysql/data
- Copy the content inside mysql/backup to the new mysql/data folder
- Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
- Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
- Start MySQL from XAMPP control panel
BOOM. It works!
I hope this tutorial can help you. Kindly visit here https://codeanddeploy.com/blog/how-to/how-to-fix-the-xampp-error-on-mysql-shutdown-unexpectedly if you want to download this code.
Happy coding :)
Original Link: https://dev.to/codeanddeploy/how-to-fix-the-xampp-error-on-mysql-shutdown-unexpectedly-4bgc
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To