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.