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
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.