View Full Version : How to retrieve Email account’s password from psa database on Linux Plesk server?

04-23-11, 01:08
You can easily retrieve an email account’s password for any particular account on the plesk server. For that,you should have root access to your Linux Plesk server.

Below are the steps to retrieve Plesk control panel password on Linux Plesk server. Note that we are retrieving database user name and password from psa (plesk) database. You will need root access OR

should have an access to mysql database and privileges to fire select query on tables in psa database.

1. Login to server through SSH.

2. Now login to mysql using command below.

# mysql -uadmin -p

Above command will ask for the password. You should enter plesk root password.

3. Then you will be able to login to mysql on the server. And see the mysql prompt.

4. Now change the database to psa using command below.

mysql> use psa

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed


5. Now use below query to retrieve the email account’s password for the particular account. You should know the domain name and replace ‘DomainName.com’ in the following query with exact domain name.

SELECTaccounts.id, mail.mail_name, accounts.password, domains.name, domains.id,mail.dom_id, mail.account_id

1.FROM domains, mail, accounts

2.Where domains.id = mail.dom_id

3.mail.account_id = accounts.id

4.domains.name = 'DomainName.com';

6. Here you can check for the email account along with the password.