(一)、在root用户下:(Mysql)
1.在root用户下:创建hive元数据库
create database if not exists hivedb;
2.在root用户下添加添加用户用户:hadoop
注意:这地方主机为localhost,可以自定义主机名,比如下面的spark1,需要统一!
insert into mysql.user(Host,User,Password)values('%','hadoop',password('hadoop'));
3.在root用户下给普通用户hadoop授权于hivedb数据库任何主机:
注意:dentified by 'hadoop' 表示密码
grant all privileges on hivedb.* to 'hadoop'@'%' identified by 'hadoop';
(二)、修改hive中的配置文件hive-site.xml
修改前:
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.137.5:3306/1608b?characterEncoding=UTF-8
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
javax.jdo.option.ConnectionUserName
root
javax.jdo.option.ConnectionPassword
root
hive.aux.jars.path
${HIVE_HOME}/auxlib
修改后:
javax.jdo.option.ConnectionURL
jdbc:mysql://192.168.137.5:3306/hivedb?characterEncoding=UTF-8
javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver
javax.jdo.option.ConnectionUserName
hadoop
javax.jdo.option.ConnectionPassword
hadoop
hive.aux.jars.path
${HIVE_HOME}/auxlib
(三)、启动hive