mysql ----------------------------------------------
admin是root角色
## 创建角色 本地连接/远程连接
CREATE USER 'userName'@'localhost' IDENTIFIED BY 'admin';
CREATE USER 'userName'@'%' IDENTIFIED BY 'admin';
## 授予操作权限
grant all privileges on testDB.* to 'userName'@'localhost' identified by 'admin';
grant all privileges on testDB.* to 'userName'@'%' identified by 'admin';
## 授予所有权限
GRANT all privileges ON mysql.* TO 'userName'@'%';
## 刷新系统权限表
flush privileges;