Linux 4 All

Best Linux tricks source

If you need to get all databases and login credentials from Plesk, the following MySQL query would do the trick:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D 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;

From Plesk 11.5 passwords are encrypted in the database, so this query will no longer return the password, but the hashed version.

Change system timezone arrow-right
Next post

arrow-left Restrict a folder from executing PHP files
Previous post

Leave a Reply

Your email address will not be published. Required fields are marked *