Plesk Repair Utility: MySQL

Using the Plesk repair utility with the mysql aspect checks the availability of MySQL database servers and verifies the integrity of MySQL databases and database users. The following options are specific to this aspect:

• -connection - Checks that the MySQL database servers registered in Plesk are available and can be connected to.
• -databases - Checks that all MySQL databases created in Plesk exist on the database servers. Recreates any databases that are missing.
• -database-users - Checks that all MySQL database users created in Plesk exist on the database servers. Checks database users' privileges and corrects them in case of discrepancies. Recreates any database users that are missing.

Examples:

plesk repair mysql - Check the availability of MySQL database servers and verify the integrity of MySQL databases and database users.

plesk repair mysql -connection - Check that the MySQL database servers registered in Plesk are available and can be connected to.

plesk repair mysql -database-users - Check that all MySQL database users created in Plesk exist on the database servers. Checks database users' privileges and corrects them in case of discrepancies. Recreates any database users that are missing.