Knowledgebase: Plesk 11

How to Impersonate the MySQL Root User via SSH

Posted by on September 01 2015 01:37 PM

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.

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Copyright © 2016 HostMySite