Using the Plesk repair utility with the mysql aspect checks the availability of MySQL/MariaDB database servers and verifies the integrity of MySQL/MariaDB databases and database users. The following options are specific to this aspect:
-connection– Checks that the MySQL/MariaDB database servers registered in Plesk are available and can be connected to.-databases– Checks that all MySQL/MariaDB databases created in Plesk exist on the database servers. Recreates any databases that are missing.-database-users– Checks that all MySQL/MariaDB 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/MariaDB database servers and verify the integrity of MySQL/MariaDB databases and database users.plesk repair mysql -connection– Checks that the MySQL/MariaDB database servers registered in Plesk are available and can be connected to.plesk repair mysql -database-users– Checks that all MySQL/MariaDB 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.