List all FTP passwords in Plesk

Login to the mysql database for Plesk

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

and run this query

SELECT REPLACE(sys_users.home,’Change this to your host PATH directory to Domain’,”) AS domain, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts on sys_users.account_id=accounts.id ORDER BY sys_users.home ASC;

 

example

SELECT REPLACE(sys_users.home,’/var/www/vhosts/’,”) AS domain, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts on sys_users.account_id=accounts.id ORDER BY sys_users.home ASC;

This entry was posted in Plesk. Bookmark the permalink.

Leave a Reply

Your email address will not be published.