beta.blog

MySQL: Obtain user list

by 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

Leave a Reply

*

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!