From: Date: September 5 2005 6:24pm
Subject: Re: Confused about privileges
List-Archive: http://lists.mysql.com/mysql/188739
Message-Id: <431C7145.8060407@aristesoftware.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Chris et al -

The MySQL online manual does show *.* to be used for global priviledges, 
but my MySQL book only used the *.  My mistake!  However, the online 
manual does not indicate (or I am missing it) what the use of * grants.

Thank you for the help...it is now working and my DB, "sfyc" does show 
in the table, "db".

Todd

Chris wrote:

> Did you run the statement witht he mysql database as the current 
> database? If so , you're statement probably got converted to this:
>
> grant all on mysql.* to todd identified by 'my_password' with grant 
> option;
>
> It seems like a logical thing
>
> The grant statement applying to all databases/tables should be:
>
> *.*
>
> Chris
>
> Todd Cary wrote:
>
>> I have created a table, "sfyc" and as root I issued the following:
>>
>> grant all on * to todd identified by 'my_password' with grant option;
>>
>> However, "todd" cannot access "sfyc" with
>>
>> mysql -u todd -p sfyc
>>
>> And the mysql db contains the following:
>>
>> user table
>> +-----------+------+
>> | host      | user |
>> +-----------+------+
>> | %         | todd |
>> | linux     | root |
>> | localhost | root |
>> +-----------+------+
>>
>> db table
>> +------+---------+------+
>> | host | db      | user |
>> +------+---------+------+
>> | %    | mysql   | todd |
>> | %    | test    |      |
>> | %    | test\_% |      |
>> +------+---------+------+
>>
>> tables_priv;
>> +------+-------+------+------------+
>> | host | db    | user | table_name |
>> +------+-------+------+------------+
>> | %    | mysql | todd | localhost  |
>> +------+-------+------+------------+
>>
>> If I issue the following command, no changes take place in the above 
>> tables:
>>
>> grant all on sfyc to todd identified by 'my_password' with grant option;
>>
>> Do I need to do an "insert SQL command" to specifically enter the 
>> information?
>>
>> Todd
>>
>
>

-- 
Ariste Software
200 D Street Ext
Petaluma, CA 94952
(707) 773-4523