The Plesk repair utility allows users to easily check and repair their Mysql database servers by verifying the integrity of their databases and database users. In this guide we’ll cover the steps necessary to check and repair your databases using the repair utility.
Repairing MySQL Databases with Plesk
To enable the Plesk repair utility, follow these steps:
- First, log in to your Plesk Onyx server 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 check that a MySQL database server registered in Plesk is available and can be connected to, use the command:
plesk repair mysql -connection
- Lastly, you’ll want to check that all the MySQL database users created in Plesk exist on the database server as well. By using the following command, Plesk will check the database users’ privileges and correct them in case of discrepancies as well as recreating any database users that are missing. To do this, use the command:
plesk repair mysql -database-users
And there you have it!
Need More Personalized Help?
If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account -> Support and provide your server credentials within the encrypted field for the best possible security and support.
If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: firstname.lastname@example.org. We are also available to you through our phone and live chat system 24/7/365.