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!