Plesk Repair Utility: MySQL/MariaDB

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.