Advanced Search

Get Plesk FTP account passwords w/o logging into MySQL

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. echo "SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS domain,
  2. sys_users.login,accounts.password FROM sys_users
  3. LEFT JOIN accounts on sys_users.account_id=accounts.id
  4. ORDER BY sys_users.home ASC;" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -t

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.