1.8K

In a Plesk-managed Linux server, administrators may sometimes need to retrieve mailbox details for a specific domain. This can be useful for auditing, troubleshooting, or managing email accounts. Plesk stores mail account information in its internal MySQL database, which can be accessed securely from the server.

Step 1: Retrieve Plesk Admin Password

The Plesk admin password is stored in an encrypted file. You can access it using:

cat /etc/psa/.psa.shadow

Copy the password, as it will be required to log in to MySQL.

Step 2: Log in to MySQL

Use the admin credentials to access the MySQL database:

mysql -u admin -p

Enter the password obtained in the previous step when prompted.

Step 3: Select the Plesk Database

Once logged in, switch to the Plesk database:

use psa;

Step 4: Retrieve Mailbox Login Details

Run the following query to list mailbox usernames and associated domain:

select m.mail_name, m.password, d.name 
from mail m, domains d 
where m.dom_id = d.id 
and d.name = 'supportpro.com';

Replace supportpro.com with your target domain.

Important Notes

• The password field is typically encrypted and not shown in plain text
• Access to this information should be restricted to authorized administrators only
• Always handle sensitive data securely

Conclusion

Accessing mailbox details through the Plesk database is a quick and effective method for administrators to manage email accounts. However, it should be used responsibly, keeping security and privacy best practices in mind.

If you need assistance with Plesk server management or database operations, feel free to contact SupportPRO Server Admin for expert help.

If you require help, contact SupportPRO Server Admin