Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to get a list of MySQL user accounts

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 2
    • 0
    • 609
    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

 0 Comment(s)

Sign In
                           OR                           
                           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: