To view the mail accounts password's in plesk

Please follow the steps,  


1. Login to the MySQL,     


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


2. Select the database.     


  use psa;  


3. View the password.   


SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id;