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;
Related Scripts with Example Source Code in same category :
