Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to get a list of MySQL user accounts

    @amuk.saxena
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 2
    • 0
    • 635
    Comment on it

    Get MySQL user accounts

     

    Hello friends, I am using MySQL and I want to list user accounts. So to do this I followed the below process:

     

    This can be done by writing the following query:

    1. SELECT User FROM mysql.user;

    This query will display you the list of user accounts as seen below:

     

     

    You can also get the lists of hosts with users by running the query:

    1. select User,Host from mysql.user;

     

    You will see the User and Host as shown below:

     

     

     

    Thanks for reading the blog.

    How to get a list of MySQL user accounts
    MySQL user accounts mysql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: