Hello.
'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
See:
http://dev.mysql.com/doc/mysql/en/drop-user.html
Gu Lei <leig@stripped> wrote:
> 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.
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
