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
    • 455
    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:

    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:

    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
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: