00-创建数据库

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jirauser'@'%' IDENTIFIED BY 'PASSWORD';
flush privileges;

#创建数据库
CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
#为数据库用户进行授权
GRANT ALL PRIVILEGES ON DATABASE jiradb  TO jirauser

-- 字符编码 AL32UTF8
#创建表空间
create tablespace jiradb datafile 'jiradb' size 100m;
create tablespace data_test datafile 'd:\oracle\oradata\data_1.dbf' size 200M;
create tablespace idx_test datafile 'd:\oracle\oradata\idx_1.dbf' size 200M;
#创建用户
create user jira identified by jira default tablespace jiradb quota unlimited on jiradb;
#对用户进行授权
grant connect to jira;
grant create table to jira;
grant create sequence to jira;
grant create trigger to jira;

[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

#not set sql_mode
#sql_mode = NO_AUTO_VALUE_ON_ZERO

transaction-isolation=READ-COMMITTED
binlog_format=row
max_connections = 250

log_bin_trust_function_creators = 1 

CREATE DATABASE confluencedb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON confluencedb.* TO 'confluenceuser'@'%' IDENTIFIED BY '<password>';
flush privileges;

#创建数据库
CREATE DATABASE confluencedb WITH ENCODING 'UTF-8' LC_COLLATE 'UTF-8' LC_CTYPE 'UTF-8' TEMPLATE template0;
#为数据库用户进行授权
GRANT ALL PRIVILEGES ON DATABASE confluencedb TO confluenceuser

--字符编码：AL32UTF8
create user confluenceuser identified by 'password' default tablespace confluencedb quota unlimited on confluencedb;
--- 授权
grant connect to confluenceuser;
grant resource to confluenceuser;
grant create table to confluenceuser;
grant create sequence to confluenceuser;
grant create trigger to confluenceuser;

CREATE ROLE bitbucketuser WITH LOGIN PASSWORD '<password>' VALID UNTIL 'infinity';
CREATE DATABASE bitbucket WITH ENCODING='UTF8' OWNER=bitbucketuser CONNECTION LIMIT=-1;

CREATE DATABASE bitbucket
USE bitbucket
ALTER DATABASE bitbucket SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE bitbucket SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE bitbucket COLLATE SQL_Latin1_General_CP1_CS_AS
SET NOCOUNT OFF
USE master
CREATE LOGIN bitbucketuser WITH PASSWORD= 'password', DEFAULT_DATABASE=bitbucket,CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
ALTER AUTHORIZATION ON DATABASE::bitbucket TO bitbucketuser

[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

#not set sql_mode
#sql_mode = NO_AUTO_VALUE_ON_ZERO

transaction-isolation=READ-COMMITTED
max_connections = 250
log_bin_trust_function_creators = 1 

create database crowddb character set utf8 collate utf8_bin;
GRANT ALL PRIVILEGES ON crowddb.* TO 'crowduser'@'%' IDENTIFIED BY 'crowdpass';

[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

transaction-isolation=READ-COMMITTED
lower_case_table_names=1
max_connections = 250
log_bin_trust_function_creators = 1 

CREATE DATABASE bamboodb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON bamboodb.* TO 'bamboouser'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

transaction-isolation=READ-COMMITTED
lower_case_table_names=1
max_connections = 250
log_bin_trust_function_creators = 1 

 SET GLOBAL storage_engine = 'InnoDB';
 CREATE DATABASE fisheye CHARACTER SET utf8 COLLATE utf8_bin;
 CREATE DATABASE crucible CHARACTER SET utf8 COLLATE utf8_bin;
 GRANT ALL PRIVILEGES ON fisheye.* TO 'fisheyeuser'@'%' IDENTIFIED BY 'password';
 GRANT ALL PRIVILEGES ON crucible.* TO 'crucibleuser'@'%' IDENTIFIED BY 'password';
 FLUSH PRIVILEGES;

CREATE USER 'atlassian'@'%'  IDENTIFIED BY mysql_native_password 'atlassian';