Plesk MySQL check from console

If you need to check and repair all database you need MySQL root password which is unknown to user when running Plesk.

Here is how to do that:

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --auto-repair -A

Please note, no space after "-p" and back quotes are important!