revoke all grant mysql usr code example Example: revokeprivileges mysql REVOKE ALL ON dbname.* FROM 'username'@'localhost';