- mysql
drop database if exists dc_test; drop user dc_test; create database dc_test; create user dc_test@'%' IDENTIFIED BY 'dc_test'; grant all privileges on dc_test.* to dc_test; flush privileges;
- postgresql
--1.创建本地存储目录 mkdir -p /data/pg/pg94data/usr_dc_ods chown -R postgres:postgres /data/pg/pg94data/ --2.登陆postgres数据库(默认的) su - postgres psql -d postgres --3.创建属于数据库db_dc的超级管理员用户 create user usr_dc_admin password '****' login ; --4.创建数据库db_dc,并绑定用户 create database db_dc with owner = usr_dc_admin encoding = 'UTF8' tablespace = pg_default lc_collate = 'en_US.UTF-8' lc_ctype = 'en_US.UTF-8' connection limit = -1; --5.切换database psql -d db_dc --6.创建表空间tp_dc_ods,并制定表空间的本地目录 create tablespace tp_dc_ods location '/data/pg/pg94data/usr_dc_ods'; --7.创建用户usr_dc_ods、密码,并且赋予登陆权限 create user usr_dc_ods password '****' login; --8.将表空间tp_dc_ods绑定给用户usr_dc_ods grant create on tablespace tp_dc_ods to usr_dc_ods; --9.创建名称为usr_dc_ods的schema,并关联到用户usr_dc_ods create schema usr_dc_ods authorization usr_dc_ods; --10.将usr_dc_ods(schema名)的使用权限赋予给usr_dc_od(用户名) grant usage on schema usr_dc_ods to usr_dc_ods;