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.