Return to Snippet

Revision: 19740
at October 29, 2009 17:45 by tobewan

Initial Code
SELECT AS domain_name, AS database_name, db_users.login, accounts.password
FROM data_bases, db_users, domains, accounts
WHERE data_bases.dom_id =
AND db_users.db_id =
AND db_users.account_id =
ORDER BY domain_name;

Initial URL

Initial Description
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:

Initial Title
Find all databases and login credentials

Initial Tags
mysql, database, server, query

Initial Language