Posted By

tobewan on 10/27/09


Tagged

sql server commands dv Dedicated-Virtual


Versions (?)

Get Plesk FTP account passwords w/o logging into MySQL


 / Published in: SQL
 

  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  

You need to login to post a comment.