hive2.1.1安装过程数据库密码问题「建议收藏」

问题一：权限问题

解决：修改权限

问题二：密码问题

我的主机是master 账户是hive 密码是hive

用密码登录无法登录

我们检查一下

select user,host,password from mysql.user;

我们删除这里面的一些数据，然后重新赋权限

（1） 删除用户为空的

use mysql

select host,user from user;

delete from user where user=’ ‘;

commit;

select host,user from user;

（2） 删除localhost和127.0.0.1

delete from user where host=’127.0.0.1′;

delete from user where host=’localhost’;

commit;

select host,user from user;

删除hive用户

delete from user where user=’hive’;

select host,user from user;

grant all privileges on hive.* to hive@’%’ identified by ‘hive’ with grant option;

grant all privileges on hive.* to hive@’master’ identified by ‘hive’ with grant option;

grant all privileges on hive.* to hive@’localhost’ identified by ‘hive’ with grant option;select host,user from user;

再次执行schematool -dbType mysql –initSchema成功初始化