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 AS domain_name, AS database_name,
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;

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 *