Loading... ## And 3.Hive的安装使用 ### 3.1.环境准备 <div class="tip inlineBlock warning simple small"> #### 3.1.1.Hive包准备: 将准备好的包均放置到hadoop01下的 `/opt/software`目录内统一管理 --- 这里需要使用的Hive包版本为 `apache-hive-3.1.2-bin.tar.gz` 官方下载:[Index of /dist/hive (apache.org)](https://archive.apache.org/dist/hive/) ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3694645491.png) mysql包为5.7:`mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar` 官方下载:[MySQL :: MySQL Community Downloads](https://dev.mysql.com/downloads/) ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/4126966633.png) </div> #### 3.1.2.计划安装目标 这里我将会把mysql安装到hadoop03上,然后将hive安装到另外两台主机上(hadoop01,hadoop02) ### 3.2.安装mysql 这里安装mysql可以参考之前文章:<div class="preview"> <div class="post-inser post box-shadow-wrap-normal"> <a href="http://www.zmzaxg.top/index.php/archives/689/" target="_blank" class="post_inser_a no-external-link no-underline-link"> <div class="inner-image bg" style="background-image: url(https://www.zmzaxg.top/usr/uploads/2023/10/1571074702.png);background-size: cover;"></div> <div class="inner-content" > <p class="inser-title">MySQL手动安装rpm包安装</p> <div class="inster-summary text-muted"> And 1.获取RPM包自建服务器暂时拆了,不提供自建备份下载,自行前往mysql.com下载压缩包解压,贴个图:... </div> </div> </a> <!-- .inner-content #####--> </div> <!-- .post-inser ####--> </div> #### 3.2.1.分发mysql包 将hadoop01的mysql压缩包拷到hadoop03主机上 ```shell scp -r /opt/software/mysql/mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar root@hadoop03:/opt/software/mysql/ ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1766991032.png) 到hadoop03主机上检查: ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2185681748.png) #### 3.2.2.解压mysql的rpm包 直接将mysql包解压 ```shell tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3523791577.png) #### 3.2.3.检查环境 在安装之前先检查一下目标环境是否有已经安装的mysql,避免出错 ```shell rpm -qa | grep mysql ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/4060731945.png) #### 3.2.4.安装和基础配置 没有问题就可以直接安装了,在当前目录下(mysql解压目录): ```shell rpm -ivh mysql-community-*.rpm --nodeps --force ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1122263750.png) ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1101665076.png) 启动mysql检查是否正常可用: ```shell systemctl start mysqldl ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2266666158.png) ```shell systemctl status mysqld ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3687470022.png) 查看mysql的默认初始密码: ```shell grep password /var/log/mysqld.log cat /var/log/mysqld.log |grep password ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3884259881.png) ```shell mysql -uroot -p ## 复杂密码有些字符可能会被shell解析,所以密码等弹出输入符后再输入 +.uuiXtm,7xp ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/359990328.png) 修改mysql默认密码,先修改密码策略: ```mysql show variables like "password"; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2034910355.png) 提示需要先修改初始密码: ```mysql set password for 'root'@'localhost' = 'P@ssword1'; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/492977243.png) 重启MySQL: ``` mysql> exit Bye [root@hadoop03 mysql]# systemctl restart mysqld ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3454294234.png) 再次登录mysql,使用已经修改的新密码: ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3010763425.png) 查看密码策略: ``` show variables like "%password%"; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3521963899.png) 将 `validate_password_length` 和 `validate_password_policy` 记下,这里需要让配置一直有效,需要修改mysqld的配置文件: ``` mysql> exit Bye [root@hadoop03 mysql]# vi /etc/my.cnf ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2687874470.png) 重启mysql: ```shell systemctl restart mysqld ``` 进入mysql修改密码: ```mysql set password for root@'localhost' = '123456'; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1771417111.png) 为了后面方便,我将mysql的root用户的host修改为 `%` 允许任何地址连接登录,可以不修改 ```mysql update mysql.user set host="%" where user='root' and host="localhost"; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3526273479.png) #### 3.2.5.为Hive创建元数据存储数据库 ```mysql create database hive character set latin1; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2410952189.png) #### 3.2.6.创建数据库用户hive并分配权限 ```mysql create user "hive"@"%" identified by "123456"; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/2777040909.png) ```mysql grant all privileges on hive.* to 'hive'@'%' with grant option; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1726206723.png) ```mysql flush privileges; -- 刷新 show grants for hive; -- 查看用户权限 ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1739122687.png) #### 3.2.7.允许从本地查看数据库用户信息 ```mysql grant all privileges on hive.* to 'hive'@'localhost' identified by '123456'; flush privileges; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/1003895059.png) ```mysql select host,user,authentication_string from mysql.user; ``` ![image.png](https://www.zmzaxg.top/usr/uploads/2023/12/3005858338.png) ### 3.3.安装Hive 最后修改:2023 年 12 月 21 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 觉得文章有用,可以赞赏请我喝瓶冰露