How to get a list of mysql user accounts

Question

Version 5.4.1

Am using command line utility and can navigate through database but now need to see the list of user accounts.

Cheers

Answer 1

Use this query:

SELECT User FROM mysql.user;

Which will output a table like this:

+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

Answer 2

If you are referring to the actual MySQL users, try:

select User from mysql.user;

Answer 3

SELECT * FROM mysql.user;

It's a big table so you might want to be more selective on what fields you choose.