hive mysql 密码 | 您所在的位置:网站首页 › hive启动不了是怎么回事 › hive mysql 密码 |
原标题:安装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成功初始化 责任编辑: |
CopyRight 2018-2019 实验室设备网 版权所有 |