MySQL: Obtain user list
by admin on Jan.17, 2011, under Random()
Sometimes it is also necessary to list all MySQL users. This can be done with the help of the following command:
select * from mysql.user;
If you wish to get the user names only, you might want to give the following command a try:
select User from mysql.user; name only