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 if there are discrepancies. Recreates any database users that are missing.

Examples:

  • plesk repair mysql - Checks the availability of MySQL database servers and verify the integrity of MySQL databases and database users.
  • plesk repair mysql -connection - Checks that the MySQL database servers registered in Plesk are available and can be connected to.
  • plesk repair mysql -database-users - Checks that all MySQL database users created in Plesk exist on the database servers. Checks database users’ privileges and corrects them if there are discrepancies. Recreates any database users that are missing.