"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
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.