Plesk: view all email accounts

mysql query
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;

Thanks to RackerHacker

DBname normally : psa

Comments are closed.