mysql新加用户设置权限

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@'%';