All Email and its password Plesk

Login to the mysql database for Plesk

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

select accounts.id, concat(mail.mail_name,’@’,domains.name), accounts.password from mail, domains, accounts  where domains.id = mail.dom_id and  mail.account_id = accounts.id;