mysql ERROR 1396 (HY000): Operation CREATE USER failed 解决办法

mysql 创建用户的时候：

create user 'hive' identified by 'hadoop';

提示错误：ERROR 1396 (HY000): Operation CREATE USER failed

解决办法：

执行放下语句：

> drop user 'hive'@'%'

> delete from mysql.user where user = 'hive'@'%';

> delete from mysql.db where user = 'hive'@'%';
> flush privileges;

重新创建用户即可成功。