//查看用户具有的权限
show grants for <username>@<host>
//授权
GRANT <权限1>[,<权限2>...] ON [TABLE|FUNCTION|PROCEDURE] <库>.<表> TO <用户>
例:建立一个具有复制权限的用户
grant replication client ,select,show view,lock tables,event,process on *.* to "bak"@"%" identified by "root";
//回收权限
revoke <权限1>[,<权限2>...] ON [TABLE|FUNCTION|PROCEDURE] <库>.<表> from <用户> ;