Hi Baron, Still i am able to connect through the following command. mysql -h 192.168.1.10 -u test -p test
although drop user can be used to drop the user but revoke command should work properly. I don't understand what is the issue. Regards, Krishna On 9/14/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > 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 >