List:General Discussion« Previous MessageNext Message »
From:Gu Lei Date:August 16 2005 2:51am
Subject:Why can't I revoke usage from user?
View as plain text  
Hello everyone:

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)

Thanks.


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