In MariaDB and Oracle MySQL, an account is a user_name@host
combination, where host can be an ip address (v4 or v6) or a
hostname. Also, the host part can be specified as a LIKE pattern
'161.58.%'). The account used by the
connection determines the privileges for that connection. When a
connection matches more than one account, only one is used, and
privileges assigned to other accounts will be ignored.
It can happen that you think that a certain client uses an account, but it uses a different account. For this reason, in this post I’ll show the queries to get all defined accounts, plus the accounts that were not used since last server startup.[Read more]