Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/email_names_passwords_by_domain_in_plesk.sql

Created November 4, 2013 14:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save siliconmeadow/7303252 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303252 to your computer and use it in GitHub Desktop.
Download ZIP
Plesk users and their passwords from a specific domain in Plesk
Raw
email_names_passwords_by_domain_in_plesk.sql
SELECT accounts.id, mail.mail_name, domains.name, SUBSTRING(accounts.password, 1) AS pw
FROM accounts, mail, domains
WHERE mail.account_id = accounts.id
AND mail.dom_id = domains.id
AND mail.mail_name LIKE '%'
AND domains.name = '<domainName>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment