1、创建test1用户授予test数据库的所有权限
grant all privileges on test.* to test1@’%’ identified by “test”;
flush privileges;
2、授予用户某个数据库所有权限:
grant all privileges on ods_test.* to test1@’%’;
3、移除权限:
revoke all privileges on onlydemo.* to test1@’%’;
flush privileges;