Reese Knowledgebase

Obtain Plesk User Account Information

View Kristian Reese's profile on LinkedIn


If you like this article, please +1 or Recommend via FB with the provided buttons above:

Article ID: 110
by: Reese K.
Posted: 26 Jun, 2013
Last updated: 26 Jun, 2013
Views: 917

Obtain Plesk User Account Information


Display Plesk FTP account passwords

SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS domain,
sys_users.login,accounts.password FROM sys_users
LEFT JOIN accounts on sys_users.account_id=accounts.id
ORDER BY sys_users.home ASC;

Display all e-mail accounts and passwords:

~# /usr/local/psa/admin/bin/mail_auth_view

-or-

SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
ORDER BY domains.name ASC,mail.mail_name ASC;

Display all databases and login credentials

SELECT domains.name AS domain_name,
data_bases.name AS database_name, db_users.login, accounts.password
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id = domains.id
AND db_users.db_id = data_bases.id
AND db_users.account_id = accounts.id
ORDER BY domain_name;

This article was:   Helpful | Not Helpful
Prev   Next
The file php is part of Plesk distribution. It cannot be run...     www as a subdomain

RSS