Hi, > Why can't I revoke usage from user? > mysql> show grants for ''@'172.20.16.110'; > +------------------------------------------+ > | Grants for @172.20.16.110 | > +------------------------------------------+ > | GRANT USAGE ON *.* TO ''@'172.20.16.110' | > +------------------------------------------+ > 1 row in set (0.00 sec) > > mysql> revoke usage on *.* from ''@'172.20.16.110'; > Query OK, 0 rows affected (0.00 sec) > > mysql> show grants for ''@'172.20.16.110'; > +------------------------------------------+ > | Grants for @172.20.16.110 | > +------------------------------------------+ > | GRANT USAGE ON *.* TO ''@'172.20.16.110' | > +------------------------------------------+ > 1 row in set (0.00 sec)
Try: revoke all from ... With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
