Mysql

mysqldump

.\mysqldump -uroot -proot -h10.168.1.111 -P3306 –database confluence > e:\test.sql

.\mysqldump -uroot -proot -h 10.168.1.111 -P3306 confluence > d:\confluence.dump

mysql -uroot -proot -h’localhost’ -P3306 confluence < d:\test.sql

.\mysqldump -uroot -proot -h 10.168.1.111 -P3306 dangdang > f:\dangdang.dump

.\mysqldump.exe -uroot -proot -h’10.168.1.111’ -P3306 dangdang > f:\dangdang.dump .\mysqldump.exe -uroot -proot -h’10.168.1.111’ -P3306 diss > f:\diss.dump

—- .\mysqldump.exe -uroot -proot -hlocalhost -P3306 dangdang > f:\dangdang.dump —- .\mysqldump.exe -uroot -proot -hlocalhost -P3306 diss > f:\diss.dump –xx .\mysqldump.exe -uroot -proot -hlocalhost -P3306 etl_meta > f:\etl_meta.dump .\mysqldump.exe -uroot -proot -hlocalhost -P3306 job_meta > f:\job_meta.dump —- .\mysqldump.exe -uroot -proot -hlocalhost -P3306 job_meta_new > f:\job_meta_new.dump .\mysqldump.exe -uroot -proot -hlocalhost -P3306 new_hivedb > f:\new_hivedb.dump —- .\mysqldump.exe -uroot -proot -hlocalhost -P3306 qzp > f:\qzp.dump

CREATE USER ‘dangdang’@’%’ IDENTIFIED BY ‘dangdang’; CREATE USER ‘qzp’@’localhost’ IDENTIFIED BY ‘qzp’;

mysql -udangdang -pdangdang -hlocalhost dangdang < e:\dangdang.dump

查看所有用户

SELECT
    User,
    Host
FROM mysql.user
;

创建用户

CREATE USER 'confluence'@'%' IDENTIFIED BY 'confluence';

创建数据库

create database confluence2  character set utf8mb4 COLLATE utf8mb4_bin;


CREATE DATABASE <database-name> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

授权

GRANT ALL PRIVILEGE ON *.* to 'confluence'@'%' identified by 'confluence';

use information_schema; select table_name, table_rows, concat(‘select '’, table_name ,’' as table_name, count(*) from ‘, TABLE_SCHEMA, ‘.’,table_name, ‘ union all’) from tables where TABLE_SCHEMA = ‘new_hivedb’ order by table_name ;

安装

mysql 数据库设置

1. mysql 数据库字符集必须为 UTF-8

CREATE DATABASE confluence 
DEFAULT CHARSET utf8 COLLATE utf8_bin;

create user confluence identified by 'confluende';

grant all privileges on confluence.* to 'confluence'@'%';

1. MySQL数据库事务隔离级别必须为 ‘READ-COMMITTED’

# 最简单的方法是修改数据库的连接串
jdbc:mysql://localhost/confluence?sessionVariables=tx_isolation='READ-COMMITTED'
jdbc:mysql://localhost/confluence?sessionVariables=tx_isolation='READ-COMMITTED'&serverTimezone=GMT%2B8

https://confluence.atlassian.com/confkb/confluence-fails-to-start-and-throws-mysql-session-isolation-level-repeatable-read-is-no-longer-supported-error-241568536.html

mysql8: jdbc:mysql://localhost/confluence?sessionVariables=transaction_isolation=’READ-COMMITTED’

1. my.cnf

[mysqld]
#tx_isolation='READ-COMMITTED'

innodb_log_file_size=2G

max_allowed_packet=256M

character_set_server=utf8

collation_server=utf8_bin

skip-character-set-client-handshake

1. 上传 MySQL 的连接包到 ~/confluence/confluencd/WEB-INF/lib 下

破解

1. 下载注册机

   下载 confluence_keygen.jar 注册机（自行百度）

2. 破解jar包

   a. 将 ~/confluence/confluence/WEB-INF/lib/atlassian-extras-decoder-v2-3.3.0.jar 复制到本地，并重命名为 atlassian-extras-2.4.jar。

   b. 运行 confluence_keygen.jar，点击 .patch，选择 atlassian-extras-2.4.jar 文件，点击打开，jar文件破解成功。

   c. 如果没有破解 jar 文件，则将机器号填入注册机之后注册不成功

3. 上传破解jar包

   将破解后的 atlassian-extras-2.4.jar 上传到服务器 ~/confluence/confluence/ WEB-INF/lib/目录下，并重命名为 atlassian-extras-decoder-v2-3.3.0.jar

4. 启动 confluence 服务，将注册信息和机器号填入注册机中，注册成功！

在 windows 中如果登陆失败三次以上需要输入验证码，但是验证码无法显示

windows下举例

1. 运行： ~\Atlassian\Confluence\bin\tomcat8w.exe //ES//Confluence220318151657

(其中：Confluence220318151657 为你的confluence服务的名称)

1. 在java options中增加：-Dfile.encoding=UTF-8

然后重启服务。

Confluence 修改密码

select u.id, u.user_name, u.active from cwd_user u  
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id  
where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';  

update cwd_user set credential =  
'{PKCS5S2}ltrb9LlmZ0QDCJvktxd45WgYLOgPt2XTV8X7av2p0mhPvIwofs9bHYVz2OXQ6/kF'  
where id=xxxxxx;