Your Webhosting Questions
Answered by the Webhosting Experts

How to Repair MySQL Databases with the Plesk (Onyx) Repair Utility

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:

  1. First, log in to your Plesk Onyx server as the root user, using your username and password.
  2. To check the availability of a MySQL database server and verify the integrity of its databases and users, use the command:

    plesk repair mysql
  3. To check that a MySQL database server registered in Plesk is available and can be connected to, use the command:

    plesk repair mysql -connection
  4. 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:

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.

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 account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your account or if you are on the go, please reach out from your valid account email to us here at: [email protected]. We are also available to you through our phone and live chat system 24/7/365.

Tags +