1、开通操作权限和表权限
GRANT CREATE,ALTER,DROP,INSERT,UPDATE,DELETE,SELECT ON interface.* TO test1@‘%‘ identified by ‘test‘ WITH GRANT OPTION; GRANT all ON interface.* TO test1@‘%‘ identified by ‘test‘ WITH GRANT OPTION;
2、移除权限
REVOKE select,CREATE,ALTER,DROP ON interface.* FROM test1@‘%‘;
原文：https://www.cnblogs.com/whalesea/p/11611732.html