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'@'%';