How to retrieve FTP account password in windows plesk

[Gaurav]

If you reset FTP password but still unable to login into your FTP account with new password, follow below commands to get the password stored on the server for your FTP account.

Open command prompt and enter below commands to get the password of any FTP account.

cd %plesk_bin%

dbclient.exe --direct-sql --sql="select * from sys_users where login='FTP_account_name'";

It will show below details for your FTP user.

id      login   account_id      home    shell   quota
1      abc      638              c:\path  no      1024

Now take account_id from above output and use it under below command to get the password. (638 is the account ID from the dbclient command we use earler)

dbclient.exe --direct-sql --sql="select * from accounts where id=638";