image.png

    1. 关闭mysql开机自启服务

    systemctl disable mysqld

    1. 开启mysql服务

    systemctl start mysqld

    1. 判断mysqld.log日志下是否生成初始密码

    grep “temporary password” /var/log/mysqld.log

    1. 设置mysql数据库本地root用户密码为123456

    mysql -uroot -p
    set global validate_password_policy=0;
    set global validate_password_length=4;
    alter user ‘root’@’localhost’ identified by ‘123456’;

    create user ‘root’@’%’ identified by ‘123456’;
    grant all privileges on _._with grant option;
    flush privileges;
    select user,host from mysql.user;
    image.png

    1. hive安装包解压到指定路径

    mkdir /usr/hive
    tar -zxvf /usr/package277/apache-hive-2.3.4-bin.tar.gz -C /usr/hive/
    cd /usr/hive/
    ls
    cd apache-hive-2.3.4-bin
    pwd
    vim etc/profile
    G
    换行
    #hive
    export HIVE_HOME=/usr/hive/apache-hive-2.3.4-bin

    1. 配置环境变量
    2. 修改HIVE运行变量，HADOOP_HOME
    3. 修改HIVE运行变量，HIVE_CONF_DIR
    4. 修改HIVE运行变量，HIVE_AUX_JARS_PATH
    5. 解决jline版本冲突