MySQL root password on a Plesk VPS\VM

Typically the Plesk vendors recommend you use the admin user set up in MySQL instead of the root MySQL user where needed.  You can find the password for the user 'admin' to MySQL as follows:

Linux:

Plesk 8-9

• Log in to the VPS via SSH
• Run the following command: 
• # cat /etc/psa/.psa.shadow

Plesk 10+

• Log in to the VPS via SSH

• Run the following command:
• # /usr/local/psa/bin/admin --show-password



Windows:
# The mysql admin password is the same as your Plesk admin password.  You can run the following command via the command prompt (logged in over console or RDP) to see it: 

"%plesk_bin%\plesksrvclient" -get