mysql创建schema和用户

1、创建schema

root用户下：

-- 数据库schema
CREATE DATABASE `HRBASE_PRO`;
 
-- 报表数据库schema
CREATE DATABASE `CUST_REPORT`;
 
-- 计件数据库schema
CREATE DATABASE `PIECE_WORK`;
 
-- 用户中心数据库schema
CREATE DATABASE `FY_USER`;

2、创建用户

root用户下：

-- 创建读写权限用户
CREATE USER 'hrbase'@'%' IDENTIFIED BY 'hrbase@111';
GRANT ALL ON HRBASE_PRO.* to 'hrbase'@'%';
GRANT ALL ON CUST_REPORT.* to 'hrbase'@'%';
GRANT ALL ON PIECE_WORK.* to 'hrbase'@'%';
GRANT SELECT ON FY_USER.* to 'hrbase'@'%';
 
-- 创建只读权限用户
CREATE USER 'hrbase_read'@'%' IDENTIFIED BY 'hrbase_read@111';
GRANT SELECT ON HRBASE_PRO.* to 'hrbase_read'@'%';
GRANT SELECT ON CUST_REPORT.* to 'hrbase_read'@'%';
GRANT SELECT ON PIECE_WORK.* to 'hrbase_read'@'%';
GRANT SELECT ON FY_USER.* to 'hrbase_read'@'%';