CDH5.16使用sqoop导入数据进入hive表遇到的坑之mysql远程访问权限和sqoopUnsupported major.minor version 52.0

CDH5.16使用sqoop导入数据进入hive表遇到的坑之mysql远程访问权限和sqoopUnsupported major.minor version 52.0

---

[mysql远程访问权限]

报错如下：Access denied for user ‘root’@‘node1’ (using password: YES)

解决：

mysql>insert into user (host,user,password) values(‘192.168.0.51’,‘root’,password(‘123’));　　
//查看一下修改
mysql>select host, user from user;
//推送设置到内存或重启服务器也行
mysql>FLUSH PRIVILEGES 　
grant all privileges on . to ‘root’@'192.168.0.49’identified by ‘123’ with grant option;
//推送设置到内存或重启服务器也行
mysql>FLUSH PRIVILEGES

[sqoopJDK冲突]

报错如下：Unsupported major.minor version 52.0

解决：

		vim /etc/profile  修改JAVA_HOME为1.7
		source /etc/profile 使之生效