On this page 
The SHOW USERS statement lists the users for all databases.
Synopsis
Required privileges
The user must have the SELECT privilege on the system table.
Example
> SHOW USERS;
+-------------+
| user_name |
+-------------+
| jpointsman |
| maxroach |
| root |
+-------------+
