Linux 4 All

Best Linux tricks source

Getting Plesk email accounts and passwords is quite easy. Here are few ways of doing that:

mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT, mail.mail_name, accounts.password, FROM domains LEFT JOIN mail ON = mail.dom_id LEFT JOIN accounts ON mail.account_id


mysql -uadmin -p$(cat /etc/psa/.psa.shadow) -D psa 
SELECT mail_name,name,password FROM mail 
LEFT JOIN domains on mail.dom_id = 
INNER JOIN accounts where mail.account_id =;"




mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT CONCAT(mail_name,"@",name) as email_address,accounts.password FROM mail
LEFT JOIN domains on
LEFT JOIN accounts on;

Some queries might not work on all Plesk versions. From 11.5 upwards the passwords are encrypted, thus only /usr/local/psa/admin/bin/mail_auth_view will work.

Restrict a folder from executing PHP files arrow-right
Next post

arrow-left Script to get users on a RHEL system
Previous post

Leave a Reply

Your email address will not be published. Required fields are marked *