Run mysql commands with plesk username

This is post is now quite old and the the information it contains may be out of date or innacurate.

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 :

Enjoy automating mysql stuff on your plesk servers!

Tags: mysqlsecuritylinuxpleskautopasswordsysadmin