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

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