Log in

View Full Version : Revoking priviliges in database


Jezebell
04-24-2004, 08:24 AM
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
04-24-2004, 12:40 PM
Remove all privilages on *.* to 'username@localhost' identified by 'password' without grant option;

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

Cripp
04-24-2004, 12:44 PM
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
04-24-2004, 12:46 PM
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