Category: SQL

1. Getting all the domain account information from Plesk ————————————————————————mysql -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e “select login,password,home from sys_users INNER JOIN accounts on accounts.id=sys_users.account_id;” 2. Get client login details from Plesk. ———————————————– mysql...