#环境 //CentOS 7.8 //Java 1.8.0 // //
自己试验玩的,所以 CentOS 环境很干净,什么也没有。
一、先安装JAVA
yum安装:
1、搜索jdk安装包
# yum search java|grep jdk
2、下载jdk1.8,下载之后默认的目录为: /usr/lib/jvm/
# yum install java-1.8.0-openjdk
3、配置环境变量及验证安装。
二、安装 MySQL
下载MySQL 安装包:
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
安装mysql 安装源:
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
在线安装MySQL,这一步时间比较久
yum -y install mysql-community-server
启动mysql 服务
systemctl start mysqld
设置开机启动
systemctl enable mysqld
systemctl daemon-reload
修改root登录密码
mysql安装完成之后,会在/var/log/mysqld.log文件中给root生成了一个临时的默认密码。
vim /var/log/mysqld.log
记住初始密码:
修改root 密码
mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'daasan7ujm^YHN';
Query OK, 0 rows affected (0.00 sec)
# 设置远程登录
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'daasan7ujm^YHN' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)
退出
mysql> exit
防火墙开放3306端口
三、创建应用数据库和账号
1).jira数据库用户帐号
mysql -u root -p Enter password: 创建数据库jira //create database jira default character set utf8 collate utf8_bin; mysql> create database jira default character set utf8mb4 collate utf8mb4_general_ci; 用户jira,密码:changeme mysql> grant all on jira.* to ‘jira’@’%’ identified by ‘changeme’; mysql>flush privileges;
2).Confluence数据库用户帐号
mysql -u root -p Enter password: 创建数据库confluence mysql> create database confluence default character set utf8mb4 collate utf8mb4_general_ci; 用户confluence,密码:changeme mysql> grant all on confluence.* to ‘confluence’@’%’ identified by ‘changeme’; mysql>flush privileges;
3).查看数据库及用户
1 mysql> select user,host from mysql.user; 2 +---------------+-----------+ 3 | user | host | 4 +---------------+-----------+ 5 | confluence | % | 6 | jira | % | 7 | root | % | 8 | mysql.session | localhost | 9 | mysql.sys | localhost | 10 +---------------+-----------+ 11 5 rows in set (0.00 sec)
4).查询数据库
1 mysql> show databases; 2 +--------------------+ 3 | Database | 4 +--------------------+ 5 | information_schema | 6 | confluence | 7 | jira | 8 | mysql | 9 | performance_schema | 10 | sys | 11 +--------------------+ 12 6 rows in set (0.00 sec)