Lost Plesk ftp login details. Plesk recover ftp password guide Linux.

Plesk recover ftp password guide.

1. Login to the server using SSH using your SSH client and login to MySQL.

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

2. Run the following MySQL query.

SELECT REPLACE(sys_users.home,’/home/httpd/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;

Unfortunately the width of this page dumps this to multiple lines, however its a one liner!

This will now display a list of all the FTP accounts including the login details.

 

Linux, Plesk Linux, Virtual & Dedicated Servers

2 responses to Lost Plesk ftp login details. Plesk recover ftp password guide Linux.


  1. kabayo

    SELECT REPLACE(sys_users.home,’/home/httpd/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;

    not work 🙁

  2. box-admin

    kabayo,

    When you say it doesn’t work. Do you get any error messages and is your Apache vhosts home directory /home/httpd/vhosts? (should have mentioned this).

    If you could also supply the output you get when executing the MySQL query that would help.

Leave a Reply

Your email address will not be published. Required fields are marked *

two + fifteen =