mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'

欧阳小白 1月前 ⋅ 29 阅读

创建用户:
create user ‘test’@’%’ identified by ‘test’;
显示ERROR 1396 (HY000): Operation CREATE USER failed for ‘test’@’%’
查看是不是存在这个用户
select user from user;
发现没有这个用户。
记得上次有删除过这个用户。可能没有刷新权限
flush privileges;
之后还是不行报错ERROR 1396 (HY000): Operation CREATE USER failed for ‘test’@’%’
没办法再删除一次:
drop user ‘test’@’%’;
flush privileges;
之后create user ‘test’@’%’ identified by ‘test’;
成功。
网上找了下原因:
Assume the user is there, so drop the user
After deleting the user, there is need to flush the mysql privileges
Now create the user.


全部评论: 0

    我有话说:

    咨询问题

    点击这里给我发消息

    淘宝咨询

    博主承接代做业务

    真·送云服务器

    咨询博主