Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/plesk_email_pwds.sql

Created November 4, 2013 14:21
Show Gist options
  • Save siliconmeadow/7303152 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303152 to your computer and use it in GitHub Desktop.
Download ZIP
Get password of plesk email user
Raw
plesk_email_pwds.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 = '<pop3UserName>'
AND domains.name = '<domainName>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment