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. This command is supported from v3.0.
You can use SHOW GRANTS FOR <user_identity>;
to view the privileges of a specific user. For more information, see SHOW GRANTS.
tip
Only users with the user_admin
role has the privilege to perform this operation.
Syntax
SHOW USERS
Return fields:
Field | Description |
---|---|
User | The user identity. |
Examples
Display all users in the system.
mysql> SHOW USERS;
+-----------------+
| User |
+-----------------+
| 'wybing5'@'%' |
| 'root'@'%' |
| 'admin'@'%' |
| 'star'@'%' |
| 'wybing_30'@'%' |
| 'simo'@'%' |
| 'wybing1'@'%' |
| 'wybing2'@'%' |
+-----------------+