--- Baron Schwartz <[EMAIL PROTECTED]> wrote:

> OK, the privileges are gone.  USAGE is a synonym for "no privileges."

Noted with tks.


>  If you want to 
> get rid of the user entirely, use DROP USER.

Could you please explain in more detail???  Where shall I add "DROP
USER"


> > To safe guard, it would be better to run 'FLUSH PRIVELEGES'.
> > 
> > Can I re-run
> > REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
> > 'vmailuser'@'localhost';
> > 
> > then
> > 
> > FLUSH PRIVELEGES;
> 
> Yes.  I think on this recent a version, it will have no effect, but
> will not harm anything.

Noted with tks.


B.R.
Stephen


Send instant messages to your online friends http://uk.messenger.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to