PDA

View Full Version : how to remove the power from a user ?


veron_23
Tue 7th Aug '01, 9:11am
by mistake i gave a user a power in all the database i have.

mysql> grant bla,bla,bla,bla,bla,bla,bla,bla
> on *.*
> to user@localhost
> identified by 'pass';


how can i remove his power from all the databases i have ?

thank you

Mark Hensler
Tue 7th Aug '01, 9:38am
Use the REVOKE (http://www.mysql.com/doc/G/R/GRANT.html) query.