-- 创建数据库
CREATE DATABASE ss_sysright DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;
-- 创建用户 @'localhost'(本地访问Only) @'%'(可以外部访问)
CREATE user 'workuser'@'localhost' IDENTIFIED BY 'Work@123';
CREATE user 'workuser'@'%' IDENTIFIED BY 'Work@123';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, ALTER ROUTINE ON ss_sysright.* TO 'workuser'@'%';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, ALTER ROUTINE ON ss_sysright.* TO 'workuser'@'localhost';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT ON mysql.`user` TO 'workuser'@'%';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT ON mysql.`user` TO 'workuser'@'localhost';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT ON mysql.`proc` TO 'workuser'@'%';
-- 授权用户CRUD以及创建表的权限
GRANT SELECT ON mysql.`proc` TO 'workuser'@'localhost';
-- revoke CREATE ON `iotbusiness123`.* FROM 'workuser'@'localhost';
-- revoke CREATE ON `iotbusiness123`.* FROM 'workuser'@'%';
-- show grants for 'workuser'@'%';
-- show grants for 'workuser'@'localhost';
-- 立即启用修改
FLUSH PRIVILEGES;