How to get a list of user accounts using the command line in MySQL

Question

I m using the MySQL command line utility and can navigate through a database  Now I need to see a list of user accounts  How can I do this   I m using MySQL version 5 4 1

User · Answer

gt   mysql -u root -p -e  Select user from mysql user   gt  allUsersOnDatabase txt   Executing this command on linux prompt will first ask for the password of mysql root user  on providing correct password it will print all the database users to the text file

User · Answer

I find this format the most useful as it includes the host field which is important in MySQL to distinguish between user records   select User Host from mysql user

User · Answer

to avoid repetitions of users when they connect from different origin   select distinct User from mysql user

User · Answer

Login to mysql as root and type following query   select User from mysql user    ------    User    ------    amon     root     root    ------

User · Answer

If you are referring to the actual MySQL users  try   select User from mysql user

User · Answer

I found his one more useful as it provides additional information about DML and DDL privileges  SELECT user  Select priv  Insert priv   Update priv  Delete priv          Create priv  Drop priv  Shutdown priv  Create user priv  FROM mysql user

User · Answer

The mysql db table is possibly more important in determining user rights  I think an entry in it is created if you mention a table in the GRANT command  In my case the mysql users table showed no permissions for a user when it obviously was able to connect and select  etc   mysql gt  select   from mysql db  mysql gt  select   from db   --------------- ----------------- -------- ------------- ------------- ------------- --------   Host            Db                User     Select priv   Insert priv   Update priv   Del

User · Answer

SELECT   FROM mysql user    It s a big table so you might want to be more selective on what fields you choose

User · Answer

I use this to sort the users  so the permitted hosts are more easy to spot   mysql gt  SELECT User Host FROM mysql user ORDER BY User Host

User · Answer

A user account comprises the username and the host level access   Therefore  this is the query that gives all user accounts  SELECT CONCAT QUOTE user      QUOTE host   UserAccount FROM mysql user

User · Answer

SELECT User FROM mysql user    use above query to get Mysql Users

User · Answer

Peter and Jesse are correct but just make sure you first select the mysql DB  use mysql  select User from mysql user   that should do your trick

User · Answer

This displays list of unique users   SELECT DISTINCT User FROM mysql user

User · Answer

MySQL stores the user information in its own database  The name of the database is MySQL  Inside that database  the user information is in a table  a dataset  named user  If you want to see what users are set up in the MySQL user table  run the following command   SELECT User  Host FROM mysql user    ------------------ -----------    User               Host         ------------------ -----------    root               localhost     root               demohost      root               127 0 0 1     debian-sys-maint   localhost                                     ------------------ -----------

User · Answer

Use this query   SELECT User FROM mysql user    Which will output a table like this    -------    User     -------    root     -------    user2    -------    As Matthew Scharley points out in the comments on this answer  you can group by the User column if you d only like to see unique usernames

[mysql] How to get a list of user accounts using the command line in MySQL?

Examples related to mysql

Examples related to command-line

Examples related to mysql5