分库分表

oceanbase 连接客户端下载地址 https://www.oceanbase.com/softwarecenter?_gl=1*1a0mktz*_ga*NTEyNDcwNjExLjE3MDU1NDkzNjE.*_ga_T35KTM57DZ*MTczNDY4MDI2NC40LjEuMTczNDY4MDM3NS4xNC4wLjA.

wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/obclient/v2.2.7/obclient-2.2.7-1.el7.aarch64.rpm
rpm -ivh obclient-2.2.7-1.el7.aarch64.rpm

obclient -h10.54.21.29 -P12883 -uroot@xxxx#xxx -pxxxx -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'@'%';

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