mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'
来源:互联网 发布:铁岭网络预约出租汽车 编辑:程序博客网 时间:2024/06/04 17:05
创建用户:
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.
http://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost
0 0
- mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'
- mysql新建root用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
- mysql创建用户ERROR 1396 (HY000): Operation CREATE USER failed for XXXXXXXX
- ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
- ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'
- Mysql错误:1396 (HY000): Operation CREATE USER failed for 'XXX'
- ERROR 1396 (HY000): Operation CREATE USER failed for 'Raikon'@'localhost' 处理
- ERROR 1396 (HY000): Operation RENAME USER failed for 'root'@'%'
- ERROR 1396 (HY000): Operation CREATE USER
- gradle报错:Execution failed for task ':XXXX:eclipseClasspath
- Error:Execution failed for task ':XXXX:processDebugManifest'.
- 1396 - Operation CREATE USER failed
- 1396 - Operation CREATE USER failed
- mysql创建数据库后出现Access denied for user 'root'@'%' to database ‘xxxx’
- mysql创建数据库后出现Access denied for user 'root'@'%' to database ‘xxxx’
- iOS 报错:process launch failed: failed to get the task for process XXXX
- 解决--Error:Execution failed for task ':xxxx:compileTestDebugAidl'.
- mysql远程访问错误:access denied for user xxxx@xxxx(using password:YES)
- 2016SDAU编程练习三1016
- python执行系统命令的方法 :os.system(),subprocess.popen(),commands
- DuiLib CreateControl
- 【Android】Activity的启动模式
- 随笔1:shell递归遍历文件夹
- mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'
- 2016SDAU编程练习三1017
- iOS: 使用CGContextRef,CGPath和UIBezierPath来绘画
- 二分查找算法
- 惊心动魄-微信抢红包传播活动
- 删除list中元素
- 1.C++--关于文件间共享代码的方法
- Socket编程------模拟QQ聊天(TCP)
- POJ 1066 Treasure Hunt(转化线段相交)