List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:August 16 2005 9:33am
Subject:Re: Why can't I revoke usage from user?
View as plain text  
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

Thread
Why can't I revoke usage from user?Gu Lei16 Aug
  • Re: Why can't I revoke usage from user?Gleb Paharenko16 Aug
  • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug
  • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug
    • RE: Why can't I revoke usage from user?Mark Leith16 Aug
      • Re: Why can't I revoke usage from user?Martijn Tonies16 Aug