How to Impersonate the MySQL Root User via SSH

You may find it necessary to impersonate the MySQL root user when connected to your Plesk VPS via SSH. When installed, Plesk renames the MySQL root account to admin. The password for MySQL should be the same as the admin password for the Plesk interface. If you do not have this password, you can still run MySQL queries as the root user by using the following command to impersonate the account:

    ~# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

If you have any further questions that were not answered in this article, please contact us.