Home > MySQL, Plesk > Plesk FTP account passwords

Plesk FTP account passwords

May 5th, 2011

Open phpMyAdmin or mysql command line client, choose database pma and execute query:

USE psa;
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

It will show you all FTP users from Plesk

Categories: MySQL, Plesk Tags: , , ,
Share it |
Comments are closed.