Re: REVOKE ERROR

2007-09-17 Thread omni
On 9/16/07, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: 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

Re: REVOKE ERROR

2007-09-16 Thread Krishna Chandra Prajapati
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

REVOKE ERROR

2007-09-14 Thread Krishna Chandra Prajapati
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

Re: REVOKE ERROR

2007-09-14 Thread Baron Schwartz
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