MySQL: see all open connections to a given database?

Question

With administrative permissions in the MySQL, how to see all the open connections to a particular database in my server?

Answer 1

The command is:

SHOW PROCESSLIST

Unfortunately, it doesn't have narrowing parameters. If you want them you can do it from the command line:

mysqladmin processlist | grep database-name

Want to be a SQL expert? Join Intellipaat's SQL Certification program to learn more.