How to find currently loggrd in users in MariaDB

To find currently logged-in users in MariaDB, you can query the information_schema.processlist table. This table contains information about each client's connection to the MariaDB server, including the username of the currently logged-in users. Here's a step-by-step explanation:

1. Connect to the MariaDB Server: First, connect to your MariaDB server using a client tool such as MySQL command-line client, phpMyAdmin, or any other database management tool.

2. Execute Query: Execute the following SQL query to retrieve information about currently logged-in users:

  

   SELECT user, host, db FROM information_schema.processlist WHERE db IS NOT NULL;

   This query selects the user, host, and db (database) columns from the information_schema.processlist table. The WHERE clause filters out system processes by checking if the db column is not NULL, ensuring that only user sessions are included.

3. Interpret Results: The result of the query will display the usernames (user), hostnames (host), and databases (db) associated with currently active connections. Each row represents a separate user session.

Here's an example of the output you might see:

+--------+-----------+--------------+

| user   | host      | db           |

+--------+-----------+--------------+

| user1  | localhost | my_database  |

| user2  | ***.***.**.*| null         |

+--------+-----------+--------------+

In this example, user1 is logged in from localhost and is using the my_database database. user2 is logged in from **.**.**.**, but is not currently associated with any specific database (null).

By following these steps, you can easily find currently logged-in users in MariaDB and gain insights into the active connections to your database server.

Here are five frequently asked questions (FAQs) about finding currently logged-in users in MariaDB:-

1. Can I see the full list of users who have connected to the MariaDB server, including past connections?

   - No, the information_schema.processlist table only contains information about currently active connections. It does not retain historical data about past connections.

2. How can I identify idle or inactive user sessions in MariaDB?

   - You can identify idle or inactive user sessions by checking the time column in the information_schema.processlist table. Sessions with a high time value indicate that they have been idle for a long time and may be candidates for termination.

3. Is there a way to filter out system processes from the list of logged-in users?

   - Yes, you can filter out system processes by checking if the db column is not NULL in the information_schema.processlist table. System processes typically do not have an associated database and will have a NULL value in the db column.

4. Can I see the IP addresses of connected users in addition to their usernames?

   - Yes, you can see the IP addresses of connected users by including the host column in your query against the information_schema.processlist table. This column provides information about the client's host from which the connection originates.

5. Is there a way to terminate specific user sessions from the MariaDB server?

   - Yes, you can terminate specific user sessions by using the KILL statement in MariaDB. You need to know the ID of the session you want to terminate, which can be obtained from the ID column in the information_schema.processlist table.