MySQL Grant problem

[John Van Ostrand]

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.


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