Hosting Article V1

Retrieving Plesk Passwords From MySQL

Category: Dedicated Linux
Author: Jane83
Date: 2008/3/2
Keywords: Plesk MySQL FTP



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

  1. Log in as root in SSH.
  2. Type  mysql -uadmin -p`cat /etc/psa/.psa.shadow`, and then press Enter.
  3. Type use psa;, and then press Enter.
  4. Type select * from sys_users;, and then press Enter.
  5. 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.

Hosting Article V1
URL: http://www.powerhoster.com/domainhosting/modules/article/view.article.php/c10/1480