Run mysql commands with plesk username

Sep 14, 2011 · 1 minute read
Category: plesk

If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub

There’s a little-known trick to using the plesk admin user password to access the mysql database that works on many a plesk machine.

Effectively the plesk admin password is stored in /etc/psa/.psa.shadow - in plain text.

This means that the following commands for instance work very well as root :

mysql -uadmin -pcat /etc/psa/.psa.shadow
mytop -uadmin -pcat /etc/psa/.psa.shadow -d[databasename]
mysqldump –user=admin –password=cat /etc/psa/.psa.shadow [databasename] > /dev/null

Enjoy automating mysql stuff on your plesk servers!