Get Plesk FTP account passwords

[rohitj]

Get Plesk FTP account passwords

In order to get Plesk FTP account password from Plesk database, just execute the below query in mysql.

SELECT REPLACE(sys_users.home,'/home/httpd/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;

Follow the steps below.


Login to your server as root via SSH.

Login to your mysql

Code: [Select]

root:~# mysql  -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> use psa;
Database changed

mysql> SELECT REPLACE(sys_users.home,'/home/httpd/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;
+--------------------------------+-----------+-----------+
| domain                         | login     | password  |
+--------------------------------+-----------+-----------+
| /var/www/vhosts/domain.com    | aamhtest  | qwe123!@# |
| /var/www/vhosts/domain2.com     | mhtest    | qwe123qwe |
| /var/www/vhosts/domain3.com     | mhtest2   | qwe123qwe |
+--------------------------------+-----------+-----------+

Enjoy.......