首页 > 代码库 > hive:Access denied for user 'root'@'%'

hive:Access denied for user 'root'@'%'

配置hive全分布模式时候,在mysql里面创建用户:create user ‘hive’ identified by ‘hive’;
然后给hive帐号分配全部权限:
grant all privileges on . on ‘hive’ with grant option。结果出现了Access denied for user ‘root’@’%’。后来我先创建数据库hive:create database hive,再grant all privileges on hive.* to ‘hive’@’%’。

<script type="text/javascript"> $(function () { $(‘pre.prettyprint code‘).each(function () { var lines = $(this).text().split(‘\n‘).length; var $numbering = $(‘
    ‘).addClass(‘pre-numbering‘).hide(); $(this).addClass(‘has-numbering‘).parent().append($numbering); for (i = 1; i <= lines; i++) { $numbering.append($(‘
  • ‘).text(i)); }; $numbering.fadeIn(1700); }); }); </script>

hive:Access denied for user &#39;root&#39;@&#39;%&#39;