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.