# plesk db
MariaDB [psa]> SELECT REPLACE(sys_users.home,'/var/www/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;
+------------------------------+-------+----------------------------------------------------------------+
| domain | login | password |
+------------------------------+-------+----------------------------------------------------------------+
| /var/www/vhosts/forbidden.sd | ib | $AES-128-CBC$bNb1T0bBybgFhAkld4thEw==$3gcmtSVPmINbDt2V3xTZKw== |
| /var/www/vhosts/test.tld | uzza | $AES-128-CBC$00+89ujGj4+azMpP97O+cg==$vGSO1CwBauYRyybGkCLNdw== |
+------------------------------+-------+----------------------------------------------------------------+
2 rows in set (0.00 sec)