用户的创建
创建用户:zhangsan 密码:123456
create user 'zhangsan'@'%' IDENTIFIED by '123456';
为用户授权
将所有数据库的所有表都授权给用户:zhangsan
# 不允许将权限授权给别人
grant all on *.* to 'zhangsan';
# 允许将权限继续授权给别人
grant all on *.* to 'zhangsan' WITH GRANT OPTION;
# 将test数据库的所有表的select 和 insert 权限授权给张三
grant select,insert on test.* to 'zhangsan' with grant option;
收回用户权限
revoke all on *.* from 'zhangsan';