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
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]