测试环境搭建整套大数据系统（二：安装jdk，mysql）

一：安装JDK

参考

https://blog.csdn.net/weixin_43446246/article/details/123328558

二：安装mysql

1.因为我们安装cdh6.3.2。cdh支持的是5.6和5.7版本的mysql。
2. 步骤

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-server_5.7.36-1ubuntu18.04_amd64.deb-bundle.tar

tar xvf ./mysql-server_5.7.36-1ubuntu18.04_amd64.deb-bundle.tar

sudo apt-get install ./libmysql*
sudo apt-get install libtinfo5

sudo apt-get install ./mysql-community-client_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-client_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-community-server_5.7.36-1ubuntu18.04_amd64.deb
sudo apt-get install ./mysql-server_5.7.36-1ubuntu18.04_amd64.deb 

3. 检查mysql状态

systemctl status mysql.service

三：初始化数据库配置

1. 输入命令

sudo mysql_secure_installation

2. 这里是进行密码的校验，输入n

3. 删除匿名用户，输入n
   

4. 是否不允许root远程登陆，输入n，允许远程
   

5. 是否删除test数据库，选择不删除，输入n
   

6. 是否立即生效权限，选择是，输入y
   

到这里配置完成

7. 检查数据库状态

systemctl status mysql.service

四. 修改密码，权限

-- 修改root用户密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
-- 给root授权允许任意地址访问
CREATE USER 'root'@'%' IDENTIFIED BY '123456';
ALTER USER 'root'@'%' IDENTIFIED BY '123456';
-- 给root用户所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges; 

vim /etc/mysql/mysql.conf.d/mysqld.cnf

添加以下内容，开启binlog

log_bin = mysql-bin
binlog_format = ROW
server_id=1

修改地址为0.0.0.0

systemctl restart mysql.service

五. dbeaver进行测试