REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'demouser'@'localhost'; code example Example: revokeprivileges mysql REVOKE ALL ON dbname.* FROM 'username'@'localhost';