--- 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]