read / recover ftp password from a plesk database

Angelo Schalley
Oct, 23, 2009
Plesk Linux
3 Comments

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e “use psa; select accounts.password from accounts INNER JOIN sys_users ON accounts.id=sys_users.account_id WHERE sys_users.login=’xxxx’;”

specify sys_users.login=’xxxx’ ( user login xxxx )

3 Responses so far.

Marc says:

26/10/2010 at 14:02

Awesome, thanks
Angelo Schalley says:

26/10/2010 at 14:14

@Marc

glad i could help

regards
Angelo
d0rn says:

23/01/2013 at 10:42

Why complicated a simple INNER JOIN when you could just go with one simple WHERE clause?

select login,password FROM sys_users,accounts WHERE accounts.id=sys_users.account_id AND sys_users.login=’user_name’;