hive mysql 密码_安装hive出现数据库密码无法登录问题

原标题：安装hive出现数据库密码无法登录问题

问题一：权限问题

解决：修改权限

问题二：密码问题

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

用密码登录无法登录

我们检查一下

select user,host,password from mysql.user;

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

删除用户为空的

select host,user from user;

delete from user where user=' ';

commit;

select host,user from user;

删除localhost和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成功初始化

责任编辑：