mysql deny permission for user access to database code example

Example: revokeprivileges mysql

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