{"id":403,"date":"2011-01-31T05:51:25","date_gmt":"2011-01-31T11:51:25","guid":{"rendered":"http:\/\/blog.supportpro.com\/2011\/01\/command-to-show-the-login-details-of-each-mailbox-under-a-specific-domain-in-linux-plesk\/"},"modified":"2026-03-25T04:02:01","modified_gmt":"2026-03-25T10:02:01","slug":"command-to-show-the-login-details-of-each-mailbox-under-a-specific-domain-in-linux-plesk","status":"publish","type":"post","link":"https:\/\/www.supportpro.com\/blog\/command-to-show-the-login-details-of-each-mailbox-under-a-specific-domain-in-linux-plesk\/","title":{"rendered":"How to View Mailbox Login Details for a Domain in Plesk (Linux) ?"},"content":{"rendered":"\n

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.<\/p>\n\n\n\n

Step 1: Retrieve Plesk Admin Password<\/strong><\/h3>\n\n\n\n

The Plesk admin password is stored in an encrypted file. You can access it using:<\/p>\n\n\n\n

cat \/etc\/psa\/.psa.shadow<\/code><\/pre>\n\n\n\n
Copy the password, as it will be required to log in to MySQL.<\/p>\n\n\n\n
Step 2: Log in to MySQL<\/strong><\/h3>\n\n\n\n
Use the admin credentials to access the MySQL database:<\/p>\n\n\n\n
mysql -u admin -p<\/code><\/pre>\n\n\n\n
Enter the password obtained in the previous step when prompted.<\/p>\n\n\n\n
Step 3: Select the Plesk Database<\/strong><\/h3>\n\n\n\n
Once logged in, switch to the Plesk database:<\/p>\n\n\n\n
use psa;<\/code><\/pre>\n\n\n\n
Step 4: Retrieve Mailbox Login Details<\/strong><\/h3>\n\n\n\n
Run the following query to list mailbox usernames and associated domain:<\/p>\n\n\n\n
select m.mail_name, m.password, d.name 
from mail m, domains d 
where m.dom_id = d.id 
and d.name = 'supportpro.com';<\/code><\/pre>\n\n\n\n
\n
Replace supportpro.com<\/strong> with your target domain.<\/p>\n<\/blockquote>\n\n\n\n
Important Notes<\/strong><\/h3>\n\n\n\n