Getting all the domain account information from Plesk

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e "select login,password,home from sys_users INNER JOIN accounts on accounts.id=sys_users.account_id;"

Get client login details from Plesk

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e "select login,password from clients INNER JOIN accounts on accounts.id=clients.account_id;"

Getting all mail account login information

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e "SELECTCONCAT_WS('@',mail.mail_name,domains.name) as email ,accounts.password FROM domains,mail,accounts WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id ORDER BY domains.name ASC,mail.mail_name ASC;"

Nel pdf allegato ci sono altre funzioni per:

• creazione/cancellazione/aggiornamento indirizzi email via ssh
• gestione mailing list via ssh
• gestione database via ssh

How to get plesk account information using mysql