Accessing MySQL Using SSH with Plesk Installed

To Access MySQL Using SSH with Plesk installed

  1. Connect to your server via SSH (more info).
  2. Switch to the root user (more info).
  3. Run the following command:
    mysql -uadmin -p`cat /etc/psa/.psa.shadow`

If you need to reset your password issue the following command:

mysqladmin -uadmin -p[current] password [new]

Where [current] is your current password and [new] is the new password you want to use.