Rolling Resource

mysql> show grants for ‘olduser’@'localhost’;
+—————————————————————————————————————-+
| Grants for newuser@localhost |
+—————————————————————————————————————-+
| GRANT USAGE ON *.* TO ‘olduser’@'localhost’ IDENTIFIED BY PASSWORD ‘*D8DECEC305209EEFEC43008E1D420E1AA06B19E0′ |
| GRANT USAGE ON `database`.* TO ‘olduser’@'localhost’ WITH GRANT OPTION |
+—————————————————————————————————————-+
2 rows in set (0.00 sec)

mysql> REVOKE ALL PRIVILEGES ON `database` . * FROM ‘olduser’@'localhost’;
Query OK, 0 rows affected (0.00 sec)

mysql> REVOKE GRANT OPTION ON `database` . * FROM ‘olduser’@ ‘localhost’;
Query OK, 0 rows affected (0.00 sec)

mysql> REVOKE ALL PRIVILEGES ON * . * FROM ‘olduser’@ ‘localhost’;

mysql> DROP USER ‘olduser’@ ‘localhost’;