Checking who is using your database server

You may wish to check who is connected to your database server when debugging network connectivity, auditing security, or simply if you're curious. In Webmin, this information is just a few clicks away.

How to do it...

Follow these steps:

1. Navigate to Servers | MySQL Database Server.

2. Click the Database Connections icon.

You will see a list of active connections or a message that no clients other then Webmin are connected to the database at this time. Consider the following screenshot:

How it works...

Webmin queries your MySQL server for information about active client connections. You could gain the same information by running the SQL command SHOW PROCESSLIST in a MySQL client:

mysql> SHOW PROCESSLIST;

You will get the following output:

+------+------+-----------+------+---------+------------------+
| Id   | User | Host      | db   | Command | Info             |
+------+------+-----------+------+---------+------------------+
| 5797 | root | localhost...