Get Plesk e-mail addresses and passwords

Need a handy way to list all the email accounts and their passwords?

select CONCAT(mail_name,"@",name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;

This entry was posted on 01/02/2007 (Thursday) at 8:33 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Printed from: http://rackerhacker.com/2007/02/01/get-plesk-e-mail-addresses-and-passwords/ .
© Major Hayden 2010.

5 Comments »

ghosti says:
03.02.09 at 04:58
but.... how to show password in plain text? thanks a lot....
Joel says:
25.05.09 at 00:36
Just stumbled across this article and thought I'd share my own quick fix to display the mailbox password. Modify the SQL query to the following:
select CONCAT(mail_name,"@",name) as email_address, substring(accounts.password, '1') from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;
There's probably a more elegant solution but this seems to work
Richard says:
27.07.09 at 05:02
Beautiful major & Joel
shawnkltucker says:
03.12.09 at 12:47
Very Handy, Thanks.
Muharrem says:
22.07.10 at 19:32
Hello;
Thanks for tip. I want ask question about email passwords. I need see password with md5 on mysql database this is possible ?
Thanks Muharrem