MySQL Grant problem

[Stephen]

John Van Ostrand wrote:
> On Tue, 2006-09-19 at 22:03 -0400, Stephen wrote:
>   
>> Environment
>>
>> Ubuntu latest update, MySQL 5.0.22, client Windows XP running MySQL 
>> Query Browser
>>
>> I granted user account root on '%' with grant privileges via command 
>> line on server.
>>
>> I connect from XP using MySQL Query Browser with the root account and do:
>>
>> I create database sor
>>
>> then
>>
>> grant all privileges on sor.* to 'sor'@'localhost' identified by 'password';
>>
>> Then I
>>
>> select * from mysql.user;
>>
>> and see that user sor is created, but every permission field is N
>>
>> What is going on? Why does user 'sor' not have any privileges?
>>     
>
> Try 
>
> SELECT * FROM mysql.db
>
> You'll see the permissions there.
>
> You want to do a:
>
> FLUSH PRIVILEGES 
>
> to force mysql to re-read the tables.
>   

Thanks. I did and it looks like the permissions are there when selecting 
from mysql.db

It still looks like they are not there when selecting from mysql.user

Is this normal?

I have not been able to test user sor yet.

Thanks
Stephen

--
The Toronto Linux Users Group.      Meetings: http://gtalug.org/
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists