查看用户当前权限
show grants;
查看其他 MySQL 用户权限:
show grants for ''@'';
授权
grant on to ''@''identified by'<123>';
identified by 非必须.
撤销权限
全部权限:all privileges
revoke on from''@'';
privileges:
其他权限参考:
https://www.cnblogs.com/fslnet/p/3143344.html
http://blog.csdn.net/wulantian/article/details/38230635
来源: http://www.bubuko.com/infodetail-2456936.html