How to determine which subscription belongs to domain database user

Created:

2016-11-16 12:56:12 UTC

Modified:

2017-08-08 13:33:08 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to determine which subscription belongs to domain database user

Applicable to:

  • Plesk 12.5 for Linux

Question

How to determine which subscription belongs to domain database user?

Answer

The following command can be used:

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

Note: replace username with actual database username in the query above.

Have more questions? Submit a request
Please sign in to leave a comment.