1.创建用户
CREATE USER pxy CONNECTION LIMIT - 1 PASSWORD '123456';
2.给用户授权
ALTER USER pxy SUPERUSER; ALTER USER pxy CREATEDB; ALTER USER pxy CREATEROLE; ALTER USER pxy LOGIN; ALTER USER pxy REPLICATION;
3.创建库
create database labplatform with owner='pxy' ENCODING UTF8;
4.还原数据库
(1)方式1
注:如果此方式还原不成功,则通过第二种方式还原
.\ksql.exe -U system -d labplatform -p 3311 -f C:\Users\PXY\Downloads\date\DB_2023-07-31_10_18_11.dmp
(2)方式2
.\sys_restore.exe --username "pxy" --port "3311" --dbname "labplatform" C:\Users\PXY\Downloads\date\DB_2023-07-31_10_18_11.dmp
标签:金仓,labplatform,--,pxy,小庞,USER,ALTER,还原 From: https://www.cnblogs.com/pxyblog/p/17711690.html