MySQL安装搭建

1. MySQL介绍

2. MySQL安装

2.1 删除系统自带的MariaDB

rpm -qa | grep mariadb
yum remove mariadb-libs-5.5.56-2.el7.x86_64~

2.2 解压MySQL安装包

cd /opt/data
tar -xvf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar

2.3 安装MySql组件

rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm --force --nodeps

3. 服务启停

1、查看服务状态
 systemctl status mysqld 
2、停止服务
 service mysqld stop 
3、初始化数据库
 mysqld --initialize --console 
4、目录授权
 chown -R mysql:mysql /var/lib/mysql 
5、启动MySQL服务
 systemctl start mysqld
 systemctl status mysqld

4. 初始化账号密码

1、查看临时密码
 cat /var/log/mysqld.log 
2、用临时密码登录数据库
 mysql -uroot -p
3、修改MySQL密码
 alter USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’; 
4、设置访问权限
 grant all privileges on *.* to root@'%' identified by “123456”;

Hive安装搭建

1. hive安装

1、执行以下命令解压hive安装包
 /opt/data
 tar –zxvf apache-hive-1.1.0-bin.tar.gz –C /usr/local/software/
2、进入/usr/local/software/目录下修改hive文件名
 mv apache-hive-1.1.0-bin/ hive

2. hive-site.xml文件配置

1、在hive下的conf目录中创建hive-site.xml文件
 touch /usr/local/software/hive/conf/hive-site.xml
2、编辑hive-site.xml文件
 vi hive-site.xml
<configuration>
    <property>
        <name>javax.jdo.option.ConnectionURL</name>
        <value>jdbc:mysql://slave2:3306/hive?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>

3. 添加mysql驱动

1、复制mysql的驱动程序到hive/lib下面
 cd /opt/data
 cp mysql-connector-java-5.1.39.jar /usr/local/software/hive/lib

2、删除hadoop目录下的share/hadoop/yarn/lib目录下的老版本jline.jar
 cd /usr/local/software/hadoop/share/hadoop/yarn/lib
 rm -rf jline-0.9.94.jar

3、将hive目录下的lib目录里的jline拷贝到hadoop目录下share/hadoop/yarn/lib中
 cd /usr/local/software/hive/lib
 cp jline-2.12.jar /usr/local/software/hadoop share/hadoop/yarn/lib

4. 启动hive

进入hive目录下的bin目录运行hive
cd /usr/local/software/hive/bin
./hive