数据库

创建数据库

SHOW GRANTS FOR ‘tyszzzpretank‘@’%’;

obclient -h10.54.21.29 -P12883 -uroot@hzs_zhjy_szzzxt#HZSGJ_003 -pI3dDR5qWMY.T[18%g2=R5IZT -c -A

obclient -h10.54.21.29 -P12883 -utyszzzpretank@hzs_zhjy_szzzxt#HZSGJ_003 -ppkDFfjGdck[KkS#m8p2= -c -A

obclient -h10.54.21.29 -P12883 -unacos@hzs_zhjy_szzzxt#HZSGJ_003 -ppkEFfjGdck[KkS#otp=2 -c -A

CREATE DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON your_database_name.* TO 'newuser'@'%';

业务数据库

• 业务中台

  url: jdbc:mysql://10.54.21.29:12883/bmp_admin_isv?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true&serverTimezone=GMT%2B8
  username: bmpadminisv@hzs_zhjy_szzzxt#HZSGJ_003
  password: BiCAJmKPrLnckbaa[KkS#=8

CREATE DATABASE bmp_admin_isv CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'bmp_admin_isv'@'%' IDENTIFIED BY 'BiCAJmKPrLnckbaa[KkS#=8';
GRANT ALL PRIVILEGES ON bmp_admin_isv.* TO 'bmp_admin_isv'@'%';

登录测试

# 使用 OceanBase 客户端连接测试
obclient -h10.54.21.29 -P12883  -ubmp_admin_isv@hzs_zhjy_szzzxt#HZSGJ_003 -pBiCAJmKPrLnckbaa[KkS#=8 -c -A
# 输出下面内容，表示授权正常
obclient(bmp_admin_isv@hzs_zhjy_szzzxt)[(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| bmp_admin_isv      |
| information_schema |
+--------------------+
2 rows in set (0.005 sec)

• 图表分析

CREATE DATABASE data_analy_chart CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'data_analy_chart'@'%' IDENTIFIED BY 'Wa7C6ph8[KkS#otp=3';
GRANT ALL PRIVILEGES ON data_analy_chart.* TO 'data_analy_chart'@'%';

• 前置数据库

revoke all privileges on *.* from 'ty_szzz_pretank'@'%';
grant all privileges on ty_szzz_pretank.* to 'ty_szzz_pretank'@'%' identified by 'pkDFfjGdck[KkS#m8p2=';
grant usage on *.* to 'ty_szzz_pretank'@'%';
SHOW GRANTS FOR 'ty_szzz_pretank'@'%';

GRANT ALL PRIVILEGES ON ty_szzz_pretank.* TO 'ty_szzz_pretank'@'%';
grant all privileges on ty_szzz_pretank.* to 'ty_szzz_pretank'@'%' identified by 'pkDFfjGdck[KkS#m8p2=';

• 加密数据库

CREATE USER 'ty_szzz_encryption'@'%' IDENTIFIED BY 'pkEFfjGdck[KkS#m4p=2';
GRANT ALL PRIVILEGES ON dwd_szzzxt_standard.* TO 'ty_szzz_encryption'@'%';

ty_szzz_encryption / pkEFfjGdck[KkS#m4p=2

中间件数据库

• MinDoc

CREATE DATABASE mindoc_db_isv CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'mindoc_db_isv'@'%' IDENTIFIED BY 'WXtH7kbEWa7C6ph8[KkS#otp=2';
GRANT ALL PRIVILEGES ON mindoc_db_isv.* TO 'mindoc_db_isv'@'%';

• Nacos

CREATE DATABASE nacos CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
CREATE USER 'nacos'@'%' IDENTIFIED BY 'pkEFfjGdck[KkS#otp=2';
GRANT ALL PRIVILEGES ON nacos.* TO 'nacos'@'%';