List:General Discussion« Previous MessageNext Message »
From:Carlos Williams Date:April 22 2009 6:40pm
Subject:Re: Creating / Lookup Users For Database
View as plain text  
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams <carloswill@stripped> wrote:
> On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley <brenttech@stripped> 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 username@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_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?
>
Thread
Creating / Lookup Users For DatabaseCarlos Williams22 Apr
  • Re: Creating / Lookup Users For DatabaseUma Bhat23 Apr
Re: Creating / Lookup Users For DatabaseCarlos Williams22 Apr
  • Re: Creating / Lookup Users For DatabaseGeorge Larson22 Apr
    • Re: Creating / Lookup Users For DatabaseCarlos Williams22 Apr
      • Re: Creating / Lookup Users For DatabaseCarlos Williams22 Apr
        • Re: Creating / Lookup Users For DatabaseGeorge Larson22 Apr