添加用户
create user zx_root IDENTIFIED by 'xxxxx';
删除用户
drop user zx_root;
查看用户权限
show grants for zx_root;
修改密码
set password for zx_root =password('xxxxxx');
赋予权限
grant select on dmc_db.* to zx_root;
回收权限(如果权限不存在会报错)
revoke select on dmc_db.* from zx_root;