ERROR 1396 (HY000): Operation CREATE USER failed for &#0

ERROR 1396 (HY000): Operation CREATE USER failed for 'Raikon'@'localhost'解决办法，hy000raikon

MariaDB [mysql]> create user Raikon@localhost identified by "atenorth";

ERROR 1396 (HY000): Operation CREATE USER failed for 'Raikon'@'localhost'

因为使用旧的方法删除用户

use mysql

delete from user where User="Raikon";

这样删除用户是不支持的

即使

flush privileges;

也不行

create user Raikon@localhost identified by 'atenorth';

OK