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
