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’;