From: Krishna Chandra Prajapati (prajapatikcgmail.com)
Date: Fri Sep 14 2007 - 08:16:33 CDT

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

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

Details are as follows
OS- Debian
MySQL 5.0.32

Regards,
Krishna

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