Revoking privileges : REVOKE « Privilege « MySQL Tutorial

1. MySQL Tutorial
2. Privilege
3. REVOKE

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;