第一步、MySQL Server 配置修改并启动生效

根据上面链接，编辑配置文件 my.ini 或者 my.cnf；

[mysqld]
port=3306
max_connections=1000
max_connect_errors=10
skip-log-bin
authentication_policy=*

character_set_server=utf8mb4   // SHOW CHARACTER SET;       //SET GLOBAL character_set_server = 'utf8mb4';
collation_server=utf8mb4_bin   // SHOW COLLATION WHERE Charset = '字符集名称';  //SET GLOBAL collation_server = 'utf8mb4_general_ci';
default-storage-engine=INNODB     // SHOW VARIABLES LIKE '%storage_engine%';
transaction-isolation=READ-COMMITTED  // SHOW VARIABLES LIKE 'transaction_isolation';

innodb_default_row_format=DYNAMIC
innodb_redo_log_capacity=4G

log_bin_trust_function_creators=1

max_allowed_packet=256M
innodb_log_file_size=2GB

安装初始化：

C:\Users\Administrator> mysqld --initialize-insecure  // 1.初始化MySQL, 生成data等相关目录以及root用户及默认密码  --user=mysql --console

C:\Users\Administrator> mysqld install       // 2.注册 mysql 服务   mysqld --install "NewMySQL" --defaults-file="C:\confluence\mysql-8.0.30-winx64\my.ini"

Service successfully installed.


C:\Users\Administrator> sc delete mysql      // 删除 mysql 服务
[SC] DeleteService 成功
 
C:\Users\Administrator> net start mysql      // 3.启动 mysql 服务
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
C:\Users\Administrator> net stop mysql       // 停止 mysql 服务
  
C:\Users\Administrator>mysql -u root -p       // 4.登录 mysql
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.30 MySQL Community Server - GPL

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Windows 停止/启动 mysql

1. 点击 “开始” -> “运行”(快捷键Win+R)（以管理员身份运行）

mysql> exit
Bye
PS C:\Users\Administrator> net stop mysql         //sc stop <MySQL服务名称>             services.msc 中 服务名称
MySQL 服务正在停止.
MySQL 服务已成功停止。

PS C:\Users\Administrator> net start mysql
MySQL 服务正在启动 ...
MySQL 服务无法启动。

服务没有报告任何错误。     // 特殊情况删除服务： sc delete mysql

请键入 NET HELPMSG 3534 以获得更多的帮助。

补充：事务隔离设置

mysql> SHOW VARIABLES LIKE 'transaction_isolation';
+-----------------------+----------------+
| Variable_name         | Value          |
+-----------------------+----------------+
| transaction_isolation | READ-COMMITTED |
+-----------------------+----------------+
1 row in set, 1 warning (0.01 sec)

mysql> SET GLOBAL transaction_isolation = 'READ-COMMITTED';
Query OK, 0 rows affected (0.00 sec)

mysql>

第二步、查看当前安装MySQL版本(4种方式)

PS C:\Users\Administrator> mysql -v
PS C:\Users\Administrator> mysqld --version
C:\confluence-7.13.5\mysql-8.0.30-winx64\bin\mysql.exe  Ver 8.0.30 for Win64 on x86_64 (MySQL Community Server - GPL)
//或者进入MySQL：
PS C:\Users\Administrator> mysql -u root -p
mysql> SELECT VERSION();
mysql> SELECT @@version;
+-----------+
| VERSION() |
+-----------+
| 8.0.30    |
+-----------+
1 row in set (0.00 sec)

第三步、创建 confluence 数据库

1. 查看数据库

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| confluence         |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

2. 删除数据库

mysql> DROP DATABASE IF EXISTS confluence;
Query OK, 0 rows affected (0.03 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)

mysql>

3. 创建空 confluence 数据库：CREATE DATABASE <database-name> CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

mysql> CREATE DATABASE confluence CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
Query OK, 1 row affected (0.01 sec)

mysql>

第四步、创建数据库用户

1. 查看/删除数据库用户

mysql> SELECT user, host FROM mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| confluence       | %         |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)

mysql> DROP USER  'confluence'@'%';

Query OK, 0 rows affected (0.02 sec)

mysql> SELECT user, host FROM mysql.user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)

mysql>

2. 创建用户并授权：GRANT ALL PRIVILEGES ON <database-name>.* TO '<confluenceuser>'@'localhost' IDENTIFIED BY '<password>';

#执行允许从任何主机访问数据库
grant all on confluence.* to 'confluenceuser'@'%' identified by 'password' with grant option;
#执行允许在本地主机上进行访问。
grant all on confluence.* to 'confluenceuser'@localhost identified by 'password' with grant option;

mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluenceuser'@'localhost' IDENTIFIED BY '123456';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '123456'' at line 1
mysql>

注意：通过上文可以看出，MySQL 8.0, 以上版本不支持这种语法。正确的语法如下：

# 如果是MYSQL8可能需要按照这个方式才能创建
# 创建MYSQL用户, password 替换成你想设置的sql密码
CREATE USER 'confluenceuser'@'localhost' IDENTIFIED BY 'password'; //CREATE USER 'confluenceuser'@'%' IDENTIFIED BY 'password';
# 给用户授予本地访问权限：
GRANT ALL ON confluence.* TO 'confluenceuser'@'localhost' WITH GRANT OPTION;
# 然后提升权限
GRANT SUPER ON *.* TO 'confluenceuser'@'localhost';
# 查看用户授权
SHOW GRANTS FOR 'confluenceuser'@'localhost';

mysql> CREATE USER 'confluenceuser'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL ON confluence.* TO 'confluenceuser'@'localhost' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT SUPER ON *.* TO 'confluenceuser'@'localhost';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> SHOW GRANTS FOR 'confluenceuser'@'localhost';
+------------------------------------------------------------------------------------------+
| Grants for confluenceuser@localhost |
+------------------------------------------------------------------------------------------+
| GRANT SUPER ON *.* TO `confluenceuser`@`localhost` |
| GRANT ALL PRIVILEGES ON `confluence`.* TO `confluenceuser`@`localhost` WITH GRANT OPTION |
+------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql>

第五步、刷新权限生效, 并退出

mysql> SELECT user, host FROM mysql.user;
   
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| confluenceuser   | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
PS C:\Users\Administrator>

附录 A: 示例

C:\Users\Administrator> mysqldump -u root -p confluence > confluence_db.sql 
Enter password:

C:\Users\Administrator> mysql -u root -p   <空>    //root账号未设置密码
mysql> show  databases;

mysql> CREATE DATABASE confluence_temp CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
mysql> CREATE USER 'fixuser'@'localhost' IDENTIFIED BY '123456';
mysql> GRANT ALL ON confluence_temp.* TO 'fixuser'@'localhost' WITH GRANT OPTION;
mysql> GRANT SUPER ON *.* TO 'fixuser'@'localhost';
mysql> SHOW GRANTS FOR 'fixuser'@'localhost';
mysql> FLUSH PRIVILEGES;

`附录 B:` Confluence7.13.5ForWindows

==== 安装指导 ====

https://www.360docs.net/doc/0f8219539.html
http://blog.chinaunix.net/uid-20786208-id-5874423.html
https://www.cnblogs.com/valeb/p/17712739.html
https://blog.51cto.com/u_16007752/6120667
https://blog.csdn.net/u010991031/article/details/131919303

常见故障解决：
confluence.cfg.xml 丢失故障： https://www.cnblogs.com/xun0523/p/10716864.html

安装包：
atlassian-confluence-7.13.5-x64.exe confluence.cfg.xml (confluence-init.properties)
atlassian-jira-software-9.5.0-x64.exe dbconfig.xml

破解工具：
confluence7.4pojie.zip
confluence-pojie工具.zip

依赖包：
jdk-8u391-windows-x64.exe

mysql-connector-java-8.0.30
mysql-8.0.30-winx64_zip.exe
mysql-connector-java-8.0.30.zip

atlassian-agent-v1.3.1.zip

=============================================
MySQL数据库设置:
---------------------------------------------
mysql -u root -p <空> //root账号未设置密码
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>mysql8</database-type>
<jdbc-datasource>
<url>jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/jira?sessionVariables=default_storage_engine=InnoDB</url>
<driver-class>com.mysql.cj.jdbc.Driver</driver-class>
<jira-database-config>
<username>jira</username>
<password>123456</password>
<confluence-database-config>
<username>confluence</username>
<password>123456</password>
=============================================

posted @ 2024-09-19 17:14 suntroop 阅读(365) 评论(0) 收藏举报

刷新页面返回顶部

Confluence 7.13.5 数据库MySQL不同版本配置

第一步、MySQL Server 配置修改并启动生效

第二步、查看当前安装MySQL版本(4种方式)

第三步、创建 confluence 数据库

1. 查看数据库

第四步、创建数据库用户

附录 A: 示例

`附录 B:` Confluence7.13.5ForWindows

公告

Confluence 7.13.5 数据库MySQL不同版本配置

第一步、MySQL Server 配置修改并启动生效

第二步、查看当前安装MySQL版本(4种方式)

第三步、创建 confluence 数据库

1. 查看数据库

第四步、创建数据库用户

附录 A: 示例

附录 B: Confluence7.13.5ForWindows

公告

`附录 B:` Confluence7.13.5ForWindows