ERROR 1396 (HY000): Operation CREATE USER failed for ‘root‘@‘%‘

Mysql创建用户时执行 create user ‘root’@’%’ identified by ‘Zhonghui@123

出现如下错误：

ERROR 1396 (HY000): Operation CREATE USER failed for ‘root’@’%’

mysql>  create user 'root'@'%' identified by 'Xielei@123';
ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'%'

原因分析：

1.已经存在了root用户
2.在执行删除root用户的时候没有删除干净

解决方法：

重新进行删除。

mysql> drop user root@'%';
Query OK, 0 rows affected (0.00 sec)
 
mysql> 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)