Retrieving Plesk Passwords From MySQL
If you have multiple users on one Plesk account and need to FTP content without editing the FTP password, you can retrieve the password from MySQL.
To Retrieve a Plesk Password From MySQL
- Log in as root in SSH.
- Type
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
, and then press Enter. - Type
use psa;
, and then press Enter. - Type
select * from sys_users;
, and then press Enter. - Type
select * from accounts where id = 2;
, and then press Enter.
A table displays that shows the id, type, and password for accounts where the ID = 2.