revoke drop table permissions mysql code example Example: revokeprivileges mysql REVOKE ALL ON dbname.* FROM 'username'@'localhost';