Plesk: show all FTP accounts and passwords

Here’s a query you can use to retrieve all the FTP account information from the Plesk internal database. It will show you each username and password of the accounts that have been created via the Plesk Controlpanel.

Update 2014: This only works for Plesk 9.x. Any Plesk version higher than 10 will have the passwords encrypted in the database. This is no longer valid. If you still run Plesk 9.x, you should upgrade immediately as it is no longer supported!

First, log into the MySQL database.

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

And copy/paste the following query into it.

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;

The end result should look similar to this.

mysql> 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;
+------------------------------------------+------------------+------------------+
| domain                                   | login            | password         |
+------------------------------------------+------------------+------------------+
| something  .be                           | someothername    | somethingelse    |
| somethingelse.be                         | someusername     | somethingelse    |
...

And that should list all the FTP users that are known to Plesk, including their passwords in plain text.