MySQL Server – Get List of Connected Users

List of Connected Users – MySQL

Is your Server responding slowly? Do you like to know the active connections to your MySQL Server? Are you worried if an unauthorized connection has been made? Now you can check the active connections made to your MySQL server at this time.

To get the list of connected users to MySQL Server, login to MySQL Server, and run the following SQL Query in mysql command line interface.

SHOW PROCESSLIST;

Now, as a test, we shall login using another username and run the above SQL Query again.

We are logging as user ‘java’.

Run the query, SHOW PROCESSLIST;, again.

There is a new connection made by user, ‘java’. And the user is currently accessing the database ‘studyboard’.