To Access MySQL Using SSH with Plesk installed
- Connect to your server via SSH (more info).
- Switch to the root user (more info).
- 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.