How To List MySQL Database Users? – POFTUT

How To List MySQL Database Users?

MySQL database server has users to connect and use databases and tables. Users provide security for database operations. MySQL server comes with default users or in the operations a lot of users are created. In this post, we will look at how to list these users.

Connect To MySQL Database

We will connect to the MySQL database server to list user. MySQL is a tool used to manage databases, tables, users and other parts of the database.

Connect To MySQL Database

Connect To MySQL Database

List Users From User Table

User information is stored in a database named mysql which is used for internal MySQL Database operations. User table holds all the database about users. We will use the following SELECT query to get the only user named with user  column.

List Users From User Table

List Users From User Table

Get Detailed User Information

As we see there is 3 user those are created by default. We have only listed usernames. We can get other information about users like below. We will use SELECT query and list all information about users. But this will print information in a messy format as we can see below.

Get Detailed User Information

Get Detailed User Information

Get User Host Restrictions

Users for MySQL have some restriction to connect MySQL server. Host column of user table hold which user can connect from which host. We can see host information like below.

LEARN MORE  How To Check Java Version

Get User Host Restrictions

Get User Host Restrictions

In the screenshot, our MySQL server only accepts connection from localhost or all users.

Leave a Reply

Your email address will not be published. Required fields are marked *

Enjoy this blog? Please spread the word :)