[ Thanks to Sushila
for this link. ]
“Sometimes in large deployments, there are cases when
MySQL server, setup by you long time back which has been in use by
multiple teams in your organization, needs some change or update or
intrupption in its service and you are in need to know how many
clients are there which connects to this server.“One way to know is to check user table in ‘mysql’
database, you might have created individual users/databases for
your clients/users. But over the time, unless taking care
seriously, we tend to forget the exactly how many
users/scripts/machines are there making connections. May be you
have used same read-only user in various scripts scattered over
many machines which you’ve created just for a single
client.”