Posted By

tobewan on 10/27/09


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
  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.