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

最新推荐文章于 2025-07-04 21:15:51 发布

原创最新推荐文章于 2025-07-04 21:15:51 发布 · 2.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#ranger #ambari #启动报错 #权限 #解决

大数据专栏收录该内容

11 篇文章

订阅专栏

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

使用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          | Y          |
| localhost           | ambari        | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| %                   | ambari        | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | udp_zjf       | *65B3DBD1FB20F71CED8E1359A2F303B2AF41DF3A | N          | N          |
| %                   | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| localhost           | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| bgs-8p113-yangliang | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| %                   | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| %                   | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| bgs-8p113-yangliang | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| 172.24.8.115        | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | N          | Y          |
| bgs-8p113-yangliang | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | N          | Y          |
| bgs-8p115-yangliang | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | N          | Y          |
| 172.24.8.113        | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | N          | Y          |
| 172.24.8.118        | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| localhost           | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| 172.24.8.113        | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| bgs-8p113-yangliang | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| %                   | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
+---------------------+---------------+-------------------------------------------+------------+------------+
32 rows in set (0.00 sec)

可以看到root用户localhost的 grant权限是N没有打开,因为ranger需要root用户localhost进行授权
打开root的localhost的grant权限进行修复

mysql> UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
mysql> FLUSH PRIVILEGES;
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 | Y          | Y          |
| localhost           | ambari        | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| %                   | ambari        | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | udp_zjf       | *65B3DBD1FB20F71CED8E1359A2F303B2AF41DF3A | N          | N          |
| %                   | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| localhost           | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| bgs-8p113-yangliang | udp_li        | *7FEFBA3B5A6420E3720C09F67EA634631F74390E | N          | N          |
| %                   | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| %                   | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| bgs-8p113-yangliang | hive          | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| localhost           | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| 172.24.8.115        | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| bgs-8p113-yangliang | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| bgs-8p115-yangliang | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| 172.24.8.113        | root          | *F861720E101148897B0F5239DB926E756B1C28B3 | Y          | Y          |
| 172.24.8.118        | udp_z         | *507BC362574FA5E50E0311C5B2600D5D688C0A31 | N          | N          |
| localhost           | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| 172.24.8.113        | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| bgs-8p113-yangliang | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
| %                   | rangeradmin   | *2C0870382CE134C9AF846C9D51709C26435A50E9 | N          | N          |
+---------------------+---------------+-------------------------------------------+------------+------------+
32 rows in set (0.00 sec)

再次重启即可解决问题