参考

安装MySQL

检查是否有mysql或者mariadb的包
rpm -qa | grep mariadb
发现有个mariadb-libs，可能也没啥用
yum remove mariadb-libs删除吧

  1. wget http://mirrors.ustc.edu.cn/mysql-repo/mysql57-community-release-el7-9.noarch.rpm
  2. yum install mysql57-community-release-el7-9.noarch.rpm
  3. yum install mysql-community-server

关闭强密码

  1. vim /etc/my.cnf
  2. # 增加如下内容
  3. plugin-load=validate_password.so
  4. validate-password=OFF

启动，查看随机密码

service mysqld start
grep "password" /var/log/mysqld.log

[Note] A temporary password is generated for root@localhost: r+RWXg*a7e%1

改密码

mysql> SET PASSWORD = PASSWORD('123456');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
mysql> flush privileges;
mysql> use  mysql
mysql> select  User,authentication_string,Host from user;
mysql> grant all privileges on *.* to root@"%" identified by "123456";
mysql> flush privileges;

启动service mysqld start，开机启动：

systemctl enable mysqld.service  # 注意此处，参考链接中缺了.service

配置Hive

下载connector
https://cdn.mysql.com/archives/mysql-connector-java-5.1/mysql-connector-java-5.1.49.tar.gz
放到$HIVE_HOME/lib

替换jline版本

hadoop/share/hadoop/yarn/lib/jline版本是0.9.94，要替换成hive/lib中的jline，版本是2.12

修改配置

链接中，初始提供的配置中有些内容会让hive运行变慢，注释掉flink test之后的部分即可