mysql、hive安装部署

前提

1、已经关闭了selinux
2、已经安装jdk
3、已经关闭防火墙
4、已经配置了免密登入
5、设置防火墙开机不自启动
6、已经安装了hadoop

一、安装Mysql

1、使用yum安装mysql

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

安装数据库

yum install mysql-community-server -y

查看状态

systemctl status mysqld

2、启动服务、设置开机自启，并且修改my.cnf文件等会来设置比较简单的密码

启动服务
systemctl start mysqld
开机自启
chkconfig mysqld on 

[root@master conf]# vim /etc/my.cnf

# 开启简单密码验证 跳过检查

skip-grant-tables

3、查看Mysql 临时密码

cat /var/log/mysqld.log | grep temp

4、登入修改密码，进行赋权
这里我们直接进行修改密码的时候可能会出现异常

alter user root@localhost identified by '123456';

grant all privileges on . to 'root'@'%' identified by '123456' with grant option;
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 'to 'root'@'%' identified by '123456' with grant option' at line 1

高版本数据库不能按照grant all privileges on . to “root”@"%" identified by “xxxx”;去修改用户权限

mysql> create user 'root'@'%' identified by  '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)



再次查看发现有了root % 
mysql> select User,Host from mysql.user;
+---------------+-----------+
| User          | Host      |
+---------------+-----------+
| root          | %         |
| mysql.session | localhost |
| mysql.sys     | localhost |
| root          | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

完成，接下来就可以使用远程连接工具连接了

二、安装Hive

1、上传解压

2、修改hive-env.sh文件

cd  /export/servers/hive-1.1.0-cdh5.14.0/conf
cp hive-env.sh.template hive-env.sh
vim hive-env.sh

添加自己hadoop路径，配置好自己hive的conf路径

HADOOP_HOME=/export/servers/hadoop-2.6.0-cdh5.14.0
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/export/servers/hive-1.1.0-cdh5.14.0/conf

3、修改hive-site.xml（添加文件

<configuration>
      <property>
        <name>hive.metastore.warehouse.dir</name>
        <value>/home/local/hive-metastore-dir/warehouse</value>

      </property>

    <property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://192.168.100.251:3306/hivedb?createDatabaseIfNotExist=true</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionDriverName</name>
      <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>root</value>
    </property>
    <property>
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>123456</value>
    </property>

</configuration>

4、将mysql驱动导入到hive的lib下

5、配置环境变量

vim /etc/profile.d/hive.sh

export HIVE_HOME=/export/servers/hive-1.1.0-cdh5.14.0
export PATH=$ PATH:$HIVE_HOME/bin

6、分发其余节点刷新环境变量

scp -r /export/servers/hive-1.1.0-cdh5.14.0/ node02:/export/servers/
scp -r /export/servers/hive-1.1.0-cdh5.14.0/ node03:/export/servers/


scp -r /etc/profile.d/hive.sh node02:/etc/profile.d/
scp -r /etc/profile.d/hive.sh node03:/etc/profile.d/

source /etc/profile

测试

并且其他节点上也能看见