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.
