MySQL List Users

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/mysql-list-users/
PINTEREST
PINTEREST
INSTAGRAM

MySQL database server have users to connect and use databases and tables. Users provides 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 how to list these users.

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

User information is stored in database named mysql which is used for internal mysql operations. User table holds all the database about users.

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.

Get User Host Restriction

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.

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

RSS
EMAIL
FACEBOOK
FACEBOOK
GOOGLE
GOOGLE
https://www.poftut.com/mysql-list-users/
PINTEREST
PINTEREST
INSTAGRAM

LEARN MORE  Python String Variable Type

You may also like...

Leave a Reply

Your email address will not be published.

Enjoy this blog? Please spread the word :)