The SHOW USERS statement lists the users for all databases.

Synopsis

SHOW USERS

Required privileges

The user must have the SELECT privilege on the system table.

Example

copy
icon/buttons/copy
> SHOW USERS;
+-------------+
|  user_name  |
+-------------+
| jpointsman  |
| maxroach    |
| root        |
+-------------+

See also



Yes No