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