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!
- How to Fix Invalid cPanel License Error When the IP is In Fact Licensed
- How to Increase PHP Upload Limit on a cPanel Server
- How to Add a Subdomain in Plesk 12
Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.
The Hivelocity Difference
With best-in-class customer service, affordable pricing, a wide-range of fully-customizable options, and a network like no other, Hivelocity is the hosting solution you’ve been waiting for.