oracle / MySQL创建用户 数据表空间 索引表空间

1 ORACLE 创建hs_rdc用户，数据表空间，索引表空间

-- 创建账户数据表空间
declare
  v_rowcount integer;
begin
  select count(*) into v_rowcount from dual where exists(select * from v$tablespace a where a.name = upper('HS_RDC_DATA'));
  if v_rowcount > 0 then
    execute immediate 'DROP TABLESPACE HS_RDC_DATA INCLUDING CONTENTS AND DATAFILES';
  end if;
end;
/
CREATE TABLESPACE HS_RDC_DATA DATAFILE '/u01/app/oracle/oradata/rdcdat1.dbf' SIZE 300M
autoextend on next 100M maxsize 10G
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
------------------------------

-- 创建账户索引表空间
declare
  v_rowcount integer;
begin
  select count(*) into v_rowcount from dual where exists(select * from v$tablespace a where a.name = upper('HS_RDC_IDX'));
  if v_rowcount > 0 then
    execute immediate 'DROP TABLESPACE HS_RDC_IDX INCLUDING CONTENTS AND DATAFILES';
  end if;
end;
/
CREATE TABLESPACE HS_RDC_IDX DATAFILE '/u01/app/oracle/oradata/rdcidx.dbf' SIZE 300M
autoextend on next 100M maxsize 10G
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
------------------------------

COMMIT;
/

--创建用户 rdc用户 密码hundsun
declare
  v_rowcount integer;
begin
  select count(*) into v_rowcount from dual where exists(select * from all_users a where a.username = upper('hs_rdc'));
  if v_rowcount > 0 then
 	 execute immediate 'DROP USER hs_rdc CASCADE';
  end if;
end;
/
CREATE USER HS_RDC IDENTIFIED BY  hundsun DEFAULT TABLESPACE HS_RDC_DATA TEMPORARY TABLESPACE TEMP;
GRANT CONNECT TO HS_RDC;
GRANT RESOURCE TO HS_RDC;
GRANT UNLIMITED TABLESPACE TO HS_RDC;
------------------------------
COMMIT;
/

2 MYSQL，创建hs_pbs用户

--创建hs_pbs用户
CREATE database IF NOT EXISTS `hs_pbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

create user 'hs_pbs'@'%' identified by 'hundsun'; 

grant all privileges on hs_pbs.* to 'hs_pbs'@'%' identified by 'hundsun';
flush privileges;