On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams <carlosw...@gmail.com> wrote: > On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams <carlosw...@gmail.com> wrote: >> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley <brentt...@gmail.com> wrote: >>> All user information is stored in the mysql database. If you want to >>> see a list of users that have been created, query the user information >>> table. >>> select User, Host from mysql.user >>> >>> Then to see what access each user has, view the grants. >>> show grants for usern...@hostname >> >> So I should do the following or am I missing something? >> >> ================================================== >> >> mysql> use mysql; >> Reading table information for completion of table and column names >> You can turn off this feature to get a quicker startup with -A >> >> Database changed >> >> mysql> show tables; >> +---------------------------+ >> | Tables_in_mysql | >> +---------------------------+ >> | columns_priv | >> | db | >> | func | >> | help_category | >> | help_keyword | >> | help_relation | >> | help_topic | >> | host | >> | proc | >> | procs_priv | >> | tables_priv | >> | time_zone | >> | time_zone_leap_second | >> | time_zone_name | >> | time_zone_transition | >> | time_zone_transition_type | >> | user | >> +---------------------------+ >> 17 rows in set (0.00 sec) >> >> ================================================== >> >> Now I have searched the Internet to find out how I can query that >> 'user' table. How can I find the command that will show my what is in >> the 'user' table? >> > Is this what you mean?
SELECT * FROM user; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org