On this page 
The SHOW USERS statement lists the users for all databases.
Synopsis
Required Privileges
No privileges are required to list users.
Example
> SHOW USERS;
+------------+
| username |
+------------+
| jpointsman |
| maxroach |
| root |
+------------+
