To find the database names, database usernames and passwords which belong to a database in Plesk

database_creds_in_plesk.sql

SELECT domains.name, data_bases.name, db_users.login, SUBSTRING(accounts.password, 1)
FROM domains, data_bases, db_users, accounts
WHERE domains.name LIKE '%<domain.dom>%'
AND db_users.account_id = accounts.id
AND db_users.db_id = data_bases.id
AND data_bases.dom_id = domains.id
ORDER BY data_bases.id;