Book Image

Webmin Administrator's Cookbook

By : Michal Karzynski
Book Image

Webmin Administrator's Cookbook

By: Michal Karzynski

Overview of this book

Table of Contents (19 chapters)
Webmin Administrator's Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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...