SHOW USERS

Description

Displays all users in the system. Users mentioned here are user identities, not user names. For more information about user identities, see CREATE USER.

You can use SHOW GRANTS FOR <user_identity>; to view the privileges of a specific user. For more information, see SHOW GRANTS.

Note: Only the user_admin role can execute this statement.

Syntax

SHOW USERS

Return fields:

Examples

Display all users in the system.

mysql> SHOW USERS;
+-----------------+
| User            |
+-----------------+
| 'wybing5'@'%'   |
| 'root'@'%'      |
| 'admin'@'%'     |
| 'star'@'%'      |
| 'wybing_30'@'%' |
| 'simo'@'%'      |
| 'wybing1'@'%'   |
| 'wybing2'@'%'   |
+-----------------+

References

CREATE USER, ALTER USER, DROP USER