Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

Revoking privileges

Revoking privileges is almost identical to granting them as you simply substitute RE VOKE.... FROM for GRANT....TO and omit any passwords or other options. For example to REVOKE the privileges assigned to a user called 'bad': mysql> REVOKE ALL PRIVILEGES     -> ON myDatabase.*     -> FROM bad@localhost;