/ Published in: SQL
![](/img/icon_sav.png?v3)
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT domains.name AS domain_name, data_bases.name AS database_name, db_users.login, accounts.password FROM data_bases, db_users, domains, accounts WHERE data_bases.dom_id = domains.id AND db_users.db_id = data_bases.id AND db_users.account_id = accounts.id ORDER BY domain_name;
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)