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!
Popular Links
Looking for more information on Plesk? Search our Knowledge Base!
Interested in more articles about Control Panels? Navigate to our Categories page using the bar on the left or check out these popular articles:
- 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
Popular tags within this category include: cPanel, WHM, Plesk, DirectAdmin, and more.
Don’t see what you’re looking for? Use the search bar at the top to search our entire Knowledge Base.
The Hivelocity Difference
Seeking a better Dedicated Server solution? In the market for Private Cloud or Colocation services? Check out Hivelocity’s extensive list of products for great deals and offers.
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.
Unsure which of our services is best for your particular needs? Call or live chat with one of our sales agents today and see the difference Hivelocity can make for you.