ERROR 1044 (42000): Access denied for user 'xuhive'@'%' to database 'hive'

1.我首先创建了一个hive用户然后执行create database hive报错如下

ERROR 1044 (42000): Access denied for user 'xuhive'@'%' to database 'hive'

2.上网查到权限不够退出当前用户到root用户下赋予hive权限

grant all on *.* to 'hive'@'%' identified by 'hive';

3.然后在执行

 grant all on *.* to 'hive'@'localhost' identified by 'hive';

4.最后flush privileges;

5.重新切换hive用户下执行create database hive