创建库及授权
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;
PostgreSQL
#创建数据库 CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0; #为数据库用户进行授权 GRANT ALL PRIVILEGES ON DATABASE jiradb TO jirauser
Oracle
-- 字符编码 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;
Confluence数据库
MySql
数据库设置
[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;
PostgreSQL
#创建数据库 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
ORACLE
SQL
--字符编码: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;
BitBucket数据库
Bitbucket Server在MySQL5.6.16之前的版本中并不是全部兼容的(并且不建议使用Mysql)
BitBucket Datacenter版本不支持Mysql
PostgreSQL
CREATE ROLE bitbucketuser WITH LOGIN PASSWORD '<password>' VALID UNTIL 'infinity'; CREATE DATABASE bitbucket WITH ENCODING='UTF8' OWNER=bitbucketuser CONNECTION LIMIT=-1;
ORACLE
SQLServer
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
Crowd数据库
MySql
数据库设置
[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';
Bamboo数据库
MySql
数据库设置
[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;
Crucible\FishEye 数据库
MySql
数据库设置
[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';
建议
每一个应用创建一个新用户
不要使用root账户
Mysql数据驱动
- mysql5.5,5.6,5.7 可使用:mysql-connector-java-5.1.44-bin.jar
- mysql5.8 可使用:mysql-connector-java-8.0.21.jar
https://confluence.atlassian.com/crowd/mysql-4030924.html
https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html
https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-mysql-776640382.html
https://confluence.atlassian.com/fisheye/migrating-to-mysql-960155589.html