决赛内容

mysql 创建用户 访问权限开放

进入MySQL

MySQL -uroot -p

修改密码策略

set global validate_password_policy=0;

set global validate_password_length=4;

创建用户 用户名为 qingjiao 密码设置为123456

create user 'qingjiao'@'%' identified by '123456';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

修改 hive-site.xml 连接

在hive服务器 slave1 中修改 master（hive）-》slave1（hive）-》slave2（mysql）

cd $HIVE_HOME/conf && vim hive-site.xml

<configuration>

<property>

<name>hive.metastore.warehouse.dir</name>

<value>/user/hive_remote/warehouse</value>

</property>

<property>

<name>javax.jdo.option.ConnectionDriverName</name>

<value>com.mysql.jdbc.Driver</value>

</property>

<property>

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://slave2:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value>

</property>

<property>

<name>javax.jdo.option.ConnectionUserName</name>

<value>qingjiao</value>

</property>

<property>

<name>javax.jdo.option.ConnectionPassword</name>

<value>123456</value>

</property>

</configuration>