How to get a list of MySQL user accounts

manpreet Best Answer 2 years ago

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?

manpreet 2 years ago

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 |
|                  | %         |
+------------------+-----------+