26 Ago, 2009
Listar los login y bases de datos de usuario en Plesk
Posted by: leopoldomaestro In: Uncategorized
# mysql -u admin -p`cat /etc/psa/.psa.shadow` psa
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;