FTP ACCOUNTS

SELECT account_id AS ‘ID’, login AS ‘USERNAME’, password AS ‘PASSWORD’, home AS ‘HOMEDIR’ FROM sys_users S, accounts A WHERE S.account_id = A.id;

MAIL ACCOUNTS

For all Domains
SELECT account_id AS ‘ID’, mail_name AS ‘USERNAME’, password AS ‘PASSWORD’, postbox as ‘MAILBOX?’, name AS ‘DOMAIN’, redir_addr as REDIRECT FROM mail M, domains D, accounts A WHERE M.account_id = A.id AND M.dom_id = D.id ORDER BY name;

For a Specific Domain
SELECT account_id AS ‘ID’, mail_name AS ‘USERNAME’, password AS ‘PASSWORD’, postbox as ‘MAILBOX?’, name AS ‘DOMAIN’, redir_addr as REDIRECT FROM mail M, domains D, accounts A WHERE M.account_id = A.id AND M.dom_id = D.id AND D.name=’****DOMAIN_NAME****‘;

MySQL ACCOUNTS

Plesk 7
SELECT d.name AS DOMAIN, db.name AS DB, du.login as USER, du.passwd as PASS FROM db_users du, data_bases db, domains d WHERE du.db_id = db.id AND db.dom_id=d.id ORDER BY d.name, db.name;
Plesk 8 & 9
SELECT d.name AS DOMAIN, db.name AS DB, du.login as USER, a.password as PASS FROM db_users du, data_bases db, domains d, accounts a WHERE du.db_id = db.id AND db.dom_id=d.id and du.account_id=a.id ORDER BY d.name, db.name;

CLIENT ACCOUNTS

Plesk 7
SELECT id as ‘ID’, login as ‘USERNAME’, passwd as ‘PASSWORD’, cname as ‘COMPANY’ FROM clients  ORDER BY login;
Plesk 8 & 9
SELECT c.id as client, a.id as account, c.login, a.password from clients c, accounts a where a.id=c.account_id;

Related Posts

  1. Resync the IIS anonymous username and password on my Plesk server (windows)
  2. Windows Plesk “Admin” Password
  3. Default Website for an IP address in Plesk
  4. Admin account locked out of Plesk Control Panel
  5. Where Do I Change the Server Default Plesk Holding Page (linux)