DB_MODE说明

• Mysql是命令的格式是Mysql格式

创建数据库

DROP DATABASE IF EXISTS ndj2024;

MySql:
CREATE DATABASE `ndj2024` WITH OWNER = `root` ENCODING 'UTF8' connection_limit = -1 allow_connections = TRUE is_template = FALSE;
#授权
GRANT CREATE ON DATABASE `ndj2024` TO `root`;
GRANT CONNECT ON DATABASE `ndj2024` TO `root`;
GRANT TEMPORARY ON DATABASE `ndj2024` TO `root`;
GRANT TEMP ON DATABASE `ndj2024` TO `root`;

PG: 
CREATE DATABASE station WITH OWNER = root ENCODING 'UTF8' connection_limit = -1 allow_connections = TRUE is_template = FALSE;
GRANT CREATE ON DATABASE station TO root;
GRANT CONNECT ON DATABASE station TO root;
GRANT TEMPORARY ON DATABASE station TO root;
GRANT TEMP ON DATABASE station TO root;

创建模式并授权

CREATE SCHEMA  IF NOT EXISTS public2 AUTHORIZATION root;