Gleb,
> Hello.
>
> 'USAGE' means that user doesn't have any privileges. Use 'DROP USER'.
> See:
> http://dev.mysql.com/doc/mysql/en/drop-user.html
I disagree here.
"drop user" will drop the user, revoking "usage" can be something different.
If, for example, you do "grant usage on dbname.*" this is different from
then "just" a user without "usage" granted to that database.
Besides, having a user without privileges might be useful as well :-)
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