MySQL Grant problem

Stephen stephen-d-bJEeYj9oJeDQT0dZR+AlfA at public.gmane.org
Wed Sep 20 02:03:54 UTC 2006


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?

Thanks in advance.

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





More information about the Legacy mailing list