From: Baron Schwartz (baronxaprb.com)
Date: Fri Sep 14 2007 - 08:23:32 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Krishna Chandra Prajapati wrote:
> Hi All,
>
> I have create a user on server 192.168.1.10 by the command below.
> grant all on test .* to 'test''192.168.1.%' identified by 'test';
> flush privileges;
>
> after fewday i don't want the user to access the test database. So i have
> given a revoke command as below
> mysql> revoke all privileges on test .* from 'test''192.168.1.%';
> Query OK, 0 rows affected (0.08 sec)
> mysql> flush privileges;
> Query OK, 0 rows affected (0.09 sec)
>
> After then i tried to connect to test database by the command below
> mysql -h 192.168.1.10 -u test -p test
> I was surprised to see that i was able to connect to server 192.168.1.10
>
> then again i tried to revoke
> mysql> revoke all privileges on test.* from 'test''192.168.1.%';
> ERROR 1141 (42000): There is no such grant defined for user 'test' on host '
> 192.168.1.%'
>
> Still i am able to connect to server 192.168.1.10
>
> What can be the problem, whether there is any bug in mysql

No. You are probably connecting as 'test''%' or 'test''localhost' or
something like that. Check grants for those users. And if you want to
completely remove the user, use DROP USER.

Baron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]