darkarchon
Technical User
so how do we list all the users in mysql? the only one i know is "SHOW GRANTS FOR BOB" and it shows the grants for bob.
how the heck do we list/show all the users?
please help!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to show all users in mysql?
- Thread starter darkarchon
- Start date
- Status
so how do we list all the users in mysql? the only one i know is "SHOW GRANTS FOR BOB" and it shows the grants for bob.
how the heck do we list/show all the users?
please help!
mysql>use mysql
database changed.
mysql> select user, host from user;
This will give you a list of users and related host.
Bye
Qatqat
I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.
database changed.
mysql> select user, host from user;
This will give you a list of users and related host.
Bye
Qatqat
I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.
- Status