> > mysql> show grants for user3; > > +-----------------------------------+ > > | Grants for [EMAIL PROTECTED] | > > +-----------------------------------+ > > | GRANT USAGE ON *.* TO 'user3'@'%' | > > +-----------------------------------+ > > 1 row in set (0.00 sec) > > > > what am I doing wrong? > >> Near the bottom it says: > USAGE || Synonym for ``no privileges'' > > So, you succesfully removed all privileges! > >
That's something that always bugged me... If you really want to remove a user from your interface, you'll have to do it manually in the table. But why has it been implemented this way? If I want to remove a user, I don't want him/her to have no privileges, I want him/her to be completely out of the database... Anyone knows why they chose this route? Christian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]