Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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
Code Block | ||||
---|---|---|---|---|
| ||||
#创建数据库 CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0; #为数据库用户进行授权 GRANT ALL PRIVILEGES ON DATABASE jiradb TO jirauser |
Oracle
Code Block | ||||
---|---|---|---|---|
| ||||
-- 字符编码 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
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[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 |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE DATABASE confluencedb CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL PRIVILEGES ON confluencedb.* TO 'confluenceuser'@'%' IDENTIFIED BY '<password>'; flush privileges; |
PostgreSQL
Code Block | ||||
---|---|---|---|---|
| ||||
#创建数据库 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
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
--字符编码: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
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE ROLE bitbucketuser WITH LOGIN PASSWORD '<password>' VALID UNTIL 'infinity'; CREATE DATABASE bitbucket WITH ENCODING='UTF8' OWNER=bitbucketuser CONNECTION LIMIT=-1; |
ORACLE
Code Block | ||||
---|---|---|---|---|
| ||||
CREATE USER <user> IDENTIFIED BY <password> DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS; GRANT CONNECT, RESOURCE to <user>; |
SQLServer
Code Block | ||||
---|---|---|---|---|
| ||||
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 |
MySql
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE DATABASE bitbucketdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON bitbucketdb.* TO 'bitbucketuser'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES |
Crowd数据库
MySql
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[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 |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
create database crowddb character set utf8 collate utf8_bin; GRANT ALL PRIVILEGES ON crowddb.* TO 'crowduser'@'%' IDENTIFIED BY 'crowdpass'; |
Bamboo数据库
MySql
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[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 |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
CREATE DATABASE bamboodb CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL PRIVILEGES ON bamboodb.* TO 'bamboouser'@'%' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; |
Crucible\FishEye 数据库
MySql
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
[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 |
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
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; |
创建用户
Code Block | ||||
---|---|---|---|---|
| ||||
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
Attachments |
---|
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