Sometime you may want to see all of the user accounts on your MySQL server.

SELECT User FROM mysql.user;
+-------+
| User  |
+-------+
| root  |
+-------+
| user2 |
+-------+

Related External Links:

• Stack Overflow - how-to-get-a-list-of-mysql-user-accounts