Skip to content

Instantly share code, notes, and snippets.

@siliconmeadow

siliconmeadow/sftp_passwords_on_plesk.sql

Created November 4, 2013 14:31
Show Gist options
  • Save siliconmeadow/7303307 to your computer and use it in GitHub Desktop.
Save siliconmeadow/7303307 to your computer and use it in GitHub Desktop.
Download ZIP
To find the passwords for an SFTP user on Plesk
Raw
sftp_passwords_on_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