MySQL创建用户报错 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'

MySQL创建用户报错 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'

 

创建命令:  

CREATE USER 'afei'@'%' IDENTIFIED BY '123456';

 

报错：

mysql> CREATE USER 'afei'@'%' IDENTIFIED BY '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'

 

查看后数据库不存在，回忆了一下操作，手动删除过 afei  这用户，可能是这个操作引起的，现在执行命令重新删除一下

drop user 'afei'@'%';


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

 

 

 

 

扩展：参考地址，在回复中