MySQL 赋予，查看，回收用户权限

赋予权限

------------------- MySQL8 ------------------- 
# 创建用户:
CREATE USER 'zhangsan'@'%' IDENTIFIED BY 'zhangsan123';

# 授予所有权限:
GRANT ALL PRIVILEGES ON *.* TO 'zhangsan'@'%' WITH GRANT OPTION;

------------------- MySQL5.7 ------------------- 
grant all privileges on *.* to zhangsan@'%' identified by 'zhangsan123';   

查看权限

show grants for zhangsan@'%';

回收权限

REVOKE  ALL PRIVILEGES ON `xxl_job_group`.* FROM 'zhangsan'@'%';