Linux 4 All

Best Linux tricks source

Posts in the Plesk category

A nice MySQL query to get all FTP users and passwords from Plesk:

# mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT REPLACE(sys_users.home,'/home/http/vhosts/','') AS domain,
sys_users.login, accounts.password
FROM sys_users
LEFT JOIN accounts on
ORDER BY sys_users.home ASC;

If you need to get all databases and login credentials from Plesk, the following MySQL query would do the trick:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa
SELECT AS domain_name, AS database_name,
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id =
AND db_users.db_id =
AND db_users.account_id =
ORDER BY domain_name;

From Plesk 11.5 passwords are encrypted in the database, so this query will no longer return the password, but the hashed version.

Getting Plesk email accounts and passwords is quite easy. Here are few ways of doing that:

mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT, mail.mail_name, accounts.password, FROM domains LEFT JOIN mail ON = mail.dom_id LEFT JOIN accounts ON mail.account_id


mysql -uadmin -p$(cat /etc/psa/.psa.shadow) -D psa 
SELECT mail_name,name,password FROM mail 
LEFT JOIN domains on mail.dom_id = 
INNER JOIN accounts where mail.account_id =;"




mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT CONCAT(mail_name,"@",name) as email_address,accounts.password FROM mail
LEFT JOIN domains on
LEFT JOIN accounts on;

Some queries might not work on all Plesk versions. From 11.5 upwards the passwords are encrypted, thus only /usr/local/psa/admin/bin/mail_auth_view will work.