Linux 4 All

Best Linux tricks source

A nice MySQL query to get all FTP users and passwords from Plesk:

# mysql -u admin -p$(cat /etc/psa/.psa.shadow) -D psa
SELECT REPLACE(sys_users.home,'/home/http/vhosts/','') AS domain,
sys_users.login, accounts.password
FROM sys_users
LEFT JOIN accounts on sys_users.account_id=accounts.id
ORDER BY sys_users.home ASC;

How to calculate the total size of MySQL engines arrow-right
Next post

arrow-left How to install SSL certificates
Previous post

Leave a Reply

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