ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'
来源:互联网 发布:语音网络配线架图片 编辑:程序博客网 时间:2024/06/06 13:57
出现ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%',说明sonar用户已经在mysql.user表中建立,若建立该用户,需先删除该用户,步骤如下:
1. delete from mysql.user where user='sonar'; 删除用户
2.CREATE USER 'sonar'@'%'IDENTIFIED BY 'sonar';天假用户
3. flush privileges; 清理缓存
4. select * from mysql.user where user='sonar';查看该用户是否存在 ,结果是null
5. flush privileges;清理缓存
6. GRANT ALL ON sonar.* TO 'sonar'@'%' IDENTIFIED BY 'sonar';用户操作授权
阅读全文
0 0
- ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'
- ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
- mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'
- mysql创建用户ERROR 1396 (HY000): Operation CREATE USER failed for XXXXXXXX
- mysql新建root用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
- ERROR 1396 (HY000): Operation CREATE USER failed for 'Raikon'@'localhost' 处理
- Mysql错误:1396 (HY000): Operation CREATE USER failed for 'XXX'
- ERROR 1396 (HY000): Operation RENAME USER failed for 'root'@'%'
- ERROR 1396 (HY000): Operation CREATE USER
- 1396 - Operation CREATE USER failed
- 1396 - Operation CREATE USER failed
- Drop Failed for User - Error MSSQLSERVER 15421
- The Error "Login failed for user"
- error:password authentication failed for user
- ERROR 1005 (HY000): Can't create table '.\user\#sql-558_5.frm' (errno: 1
- 550 create directory operation failed
- Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
- vsftpd 550 Create directory operation failed 错误
- BZOJ1059_矩阵游戏_KEY
- 02.LuaInterface 和 luanet
- 谈谈对Spring IOC的理解
- 日常问题总结(4)
- NSIS 执行批处理
- ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'
- hdu3522 ex-kmp或hash(暂时不理解
- iOS随手整一个无限轮播图
- ArcGIS API for JavaScript开发环境搭建及第一个实例demo
- 【备忘】elk日志分析视频 ELKStack视频教程以及Solr教程
- java中数组复制的4种方式分析
- 基于Token的身份验证
- 关于AsyncTask的一个小疑问:为什么任务执行有延迟?
- Java笔记——1、环境搭建、eclipse安装、创建工程