Revoking priviliges in database

[Jezebell]

I know with:

grant all privileges on *.* to username@localhost identified by 'password' with grant option;

You can give someone access to your database.

Whats the command line to remove those privilages?

[NarutoLegacy]

Remove all privilages on *.* to 'username@localhost' identified by 'password' without grant option;

Maybe something like that... don't know.

[Cripp]

if you have mysql front, or anything, you can edit the main mysql db..
database: mysql
server: localhost
user: root
no password.
go to user table and there they are
hope this helps

[Derision]

Originally Posted by Jezebell

Whats the command line to remove those privilages?

Revoke is what you are after. Documented here:

http://dev.mysql.com/doc/mysql/en/GRANT.html