revoke all permissions mysql code example

Example 1: mysql flush privileges

FLUSH PRIVILEGES;

Example 2: revokeprivileges mysql

REVOKE ALL ON dbname.* FROM 'username'@'localhost';