Retrieving FTP Password for Specific User

To get the FTP password of a user that is contained within Plesk, access mysql and login with the admin user name and password. Then select the psa database:

SELECT accounts.password FROM accounts INNER JOIN sys_users ON accounts.id=sys_users.account_id WHERE sys_users.login='xxxx';

Where xxxx is the user name you want the password for.