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’@’%’；