ranger启动报错Access denied for user 'root'@'%' to database 'ranger'

最新推荐文章于 2023-12-17 15:17:36 发布

客尘烦恼

最新推荐文章于 2023-12-17 15:17:36 发布

阅读量2.1k

点赞数

分类专栏：大数据文章标签： ranger ambari 启动报错权限解决

本文链接：https://blog.csdn.net/lisong_ghost/article/details/78609997

版权

在Ambari中安装的Ranger启动时遇到错误：'Access denied for user 'root'@'%' to database 'ranger'。为解决此问题，可以尝试以root用户身份登录数据库，检查并开启root用户的localhost grant权限，执行相关SQL语句修复。修复后重启Ranger即可解决问题。

摘要由CSDN通过智能技术生成

使用ambari安装的ranger在启动ranger-admin时报错
Access denied for user ‘root’@’%’ to database ‘ranger’
参考解决办法：
使用root用户登录数据库，执行以下sql语句

mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
+---------------------+---------------+-------------------------------------------+------------+------------+
| host                | user          | password                                  | Grant_priv | Super_priv |
+---------------------+---------------+-------------------------------------------+------------+------------+
| localhost           | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| 127.0.0.1           | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| ::1                 | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| %                   | udp_zjf       | *65B3DBD1FB20F71CED8E1359A2F303B2AF41DF3A | N          | N          |
| bgs-8p113-yangliang | ambari        | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| %                   | swordfish_zjf | *C68242E5CCE1D6ECEADEBF782C31A20D107CA846 | N          | N          |
| %                   | swordfish     | *FC48AB2E7C214BC45A9E6B66C46016F8A53E5A28 | N          | N          |
| localhost           | swordfish_zjf | *C68242E5CCE1D6ECEADEBF782C31A20D107CA846 | N          | N          |
| localhost           | swordfish     | *FC48AB2E7C214BC45A9E6B66C46016F8A53E5A28 | N          | N          |
| %                   | swordfish_li  | *D97737CF5AAB07222042BA796B0B7E08ACCE0D43 | N          | N          |
| localhost           | swordfish_li  | *D97737CF5AAB07222042BA796B0B7E08ACCE0D43 | N          | N          |
| %                   | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | N          |