0 votes
1 view
in SQL by (6.1k points)
With administrative permissions in the MySQL, how to see all the open connections to a particular database in my server?

1 Answer

0 votes
by (12.7k points)

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.

Related questions

0 votes
1 answer
asked Dec 25, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
asked Dec 18, 2020 in SQL by Appu (6.1k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...