Display number of Client connected to Database in MySQL

Hi PSowmiya,

Refer below links.

https://www.commandlinefu.com/commands/view/9938/display-the-number-of-connections-to-a-mysql-database

https://dba.stackexchange.com/questions/115309/view-active-mysql-connections-per-user

thank you sir.

In second link, following query solves my problem

SELECT IFNULL(usr,'All Users') user,IFNULL(hst,'All Hosts') host , COUNT(1) Connections FROM ( SELECT user usr,LEFT(host,LOCATE(':',host) - 1) hst FROM information_schema.processlist WHERE user='root' ) A GROUP BY usr,hst WITH ROLLUP