grant all on *.* to root@'hadoop102' identified by '123456';
grant:授权
all:所有权限
*.*:数据库名称.表名称
root:操作mysql的用户
@'':主机名
密码:123456
如果单独使用mysql -uroot -p123456可以登录mysql表明mysql安装成功
退出当前账户用 exit; 主要不要忽略了;
6.关联mysql和hive.先配置修改hive里的hive-site.xml文件
1. hive-site.xml
<-远程用hive连接数据库,主要修改hive里的四个配置文件->
<1.hadoop102连接mysql,并且在mysql里面创建metastore数据库。>
<2.添加mysql驱动路径到hive中,前提是已在hive的lib目录下,上传了mysql连接驱动的jar包>
<3和4是hive连接mysql数据库的账户和密码>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop102:3306/metastorecreateDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>password to use against metastore database</description>
</property>
$ cp -a mysql-connector-java-5.1.27-bin.jar /opt/modules/cdh/hive-0.13.1-cdh5.3.6/lib/
8. 启动Hive和测试是否安装成功
1. $ bin/hive 出现下面字样则表示全部安装成功
17/07/22 09:04:02 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.* no longer has any effect. Use hive.hmshandler.retry.* nstead Logging initialized using configuration in jar:file:/opt/modules/hive-0.13.1-cdh5.3.6/lib/hive-common-0.13.1-cdh5.3.6.jar!/hive-log4j.properties