How to get a list of MySQL user accounts?

To get the list of MySQL user accounts, we can use “SELECT USER”.

The following is the query to display the list.

SELECT User FROM mysql.user;

Here is the output.

+------------------+
| User             |
+------------------+
| John             |
| Mac              |
| Manish           |
| mysql.infoschema |
| mysql.session    |
| mysql.sys        |
| root             |
| am               |
+------------------+
8 rows in set (0.00 sec)

The above output displays all the user accounts. Here is the query that gives corressponding host.

mysql> select User,Host from mysql.user;

The following is the output.

+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| John             | %         |
| Mac              | %         |
| Manish           | %         |
| mysql.infoschema | %         |
| mysql.session    | %         |
| mysql.sys        | %         |
| root             | %         |
| am               | localhost |
+------------------+-----------+
8 rows in set (0.00 sec)

Arjun Thakur

Updated on: 30-Jul-2019

99 Views

Kickstart Your Career

Get certified by completing the course

Get Started