Retrieving Plesk Passwords From MySQL
Last Updated:
September 11, 2006 2:59 PM
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.
