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

来源：互联网发布：java返回前台乱码编辑：程序博客网时间：2024/06/03 15:53

使用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)

再次重启即可解决问题

阅读全文

0 0