mysql建库语句

-- 创建数据库
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;