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?
>
