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.

</>
Copy
SHOW PROCESSLIST;
MySQL - 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’.

MySQL another user login

Run the query, SHOW PROCESSLIST;, again.

MySQL - SHOW PROCESSLIST

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