mysql -uadmin -pXXXXX
use psa;
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;
y para ver las password de las cuentas de FTP:
mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e “use psa; select sys_users.login,accounts.password from accounts INNER JOIN sys_users ON accounts.id=sys_users.account_id”;
En plesk 11 o superior:
/usr/local/psa/admin/sbin/mail_auth_view