Login to mySql on Plesk

[SevenZero]

Here is a quick way to login to the mysql database on a system with Plesk with admin privileges.

Code: Select all

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

You can view the password if you like as below.

Code: Select all

cat /etc/psa/.psa.shadow

If it is Plesk 10, then use this:

Code: Select all

/usr/local/psa/bin/admin --show-password