Posted By

tobewan on 10/29/09


mysql database server query users dv Dedicated-Virtual

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Find all databases and login credentials

 / Published in: SQL

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:

  1. SELECT AS domain_name,
  2. AS database_name, db_users.login, accounts.password
  3. FROM data_bases, db_users, domains, accounts
  4. WHERE data_bases.dom_id =
  5. AND db_users.db_id =
  6. AND db_users.account_id =
  7. ORDER BY domain_name;

Report this snippet  

You need to login to post a comment.