Plesk database utils

List Plesk username and password for a client:

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa;
select clients.login , accounts.password from clients 
left join domains on clients.id=domains.cl_id 
left join accounts on accounts.id=clients.account_id 
where domains.name="DOMAIN";

List FTP username and password for a domain:

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa;
select sys_users.login, accounts.password from accounts 
left join sys_users on sys_users.account_id=accounts.id 
where sys_users.home like "%DOMAIN";

List email addresses and passwords for a domain:

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa;
select accounts.id, mail.mail_name, accounts.password, domains.name from domains 
left join mail on domains.id = mail.dom_id 
left join accounts on mail.account_id = accounts.id 
where domains.name = 'DOMAIN';

List database users and passwords for a domain:

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa;
select data_bases.name, db_users.login, accounts.password from domains 
left join data_bases on data_bases.dom_id=domains.id 
left join db_users on data_bases.id=db_users.db_id 
left join accounts on db_users.account_id=accounts.id 
where domains.name="DOMAIN";