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 wha

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 PROTECTE

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 be

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