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 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.