Archive for the ‘Database’ Category

Plesk SQL Queries

A few queries I put together to grab info from the Plesk database for troubleshooting: #FTP ACCOUNTS #———— SELECT account_id AS ‘ID’, login AS ‘USERNAME’, password AS ‘PASSWORD’, home AS ‘HOMEDIR’ FROM sys_users S, accounts A WHERE S.account_id = A.id; #MAIL ACCOUNTS #————- SELECT account_id AS ‘ID’, mail_name AS ‘USERNAME’, password AS ‘PASSWORD’, postbox as [...]