This guide explains how to repair MySQL Database with the Plesk (Onyx) repair utility. It helps users efficiently check and repair their MySQL database servers by ensuring the integrity of their databases and users.
Follow the steps:
- Log in as the root user using your username and password.
- To check the availability of a MySQL database server and verify the integrity of its databases and users, use the command:
plesk repair mysql
- To ensure that a MySQL database server registered in Plesk is available and can be connected to, use the command:
plesk repair mysql -connection
- To check that all MySQL database users created in Plesk exist on the database server and correct any discrepancies in their privileges, use the command:
plesk repair mysql -database-users
Hope you grasped everything well. If you encounter any issues, feel free to reach out to our technical team.
If you’re using WHM and need to repair your MySQL databases, check out our comprehensive guide: How to Repair MySQL Database using WHM.