Admin-Ahead Community

Linux => Control Panels => Plesk => Topic started by: sibij on April 28, 2018, 12:09:52 pm

Title: How to find the subscription and database names by database user
Post by: sibij on April 28, 2018, 12:09:52 pm

Connect to the server via SSH and execute the following command:

Code: [Select]

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"SELECT db_users.login, data_bases.name, domains.name FROM db_users LEFT JOIN domains ON db_users.dom_id=domains.id LEFT JOIN data_bases ON data_bases.id=db_users.id WHERE db_users.login LIKE 'username'"
To find domain name by database name:

Code: [Select]

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"SELECT domains.name FROM domains LEFT JOIN data_bases ON domains.id=data_bases.dom_id WHERE data_bases.name='username'"