Recently I had to try login to a webmail account for a client. I needed their password but couldn’t remember what it was set to and didn’t really want to reset the whole password so I decided to look in the Plesk database (psa) to see if I could find it.

The database was very helpful. With the query:

select mail_name,name,password
from accounts,mail,domains
where mail.account_id=accounts.id
and mail.dom_id = domains.id where name = "domain.com";

From here it showed a list of all the emails under a set domain together with their passwords.