MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'
建立命令:
CREATE USER 'afei'@'%' IDENTIFIED BY '123456';
報錯:
mysql> CREATE USER 'afei'@'%' IDENTIFIED BY '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'
檢視後資料庫不存在,回憶了一下操作,手動刪除過 afei 這使用者,可能是這個操作引起的,現在執行命令重新刪除一下
drop user 'afei'@'%';
mysql> drop user 'afei'@'%';
Query OK, 0 rows affected (0.00 sec)
擴充套件:參考地址,在回覆中
相關文章
- MySQL 5.7 建立使用者報錯 ERROR 1805 (HY000): Column count of mysql.user is wrongMySqlError
- maridb Error 'Operation DROP USER failed forErrorAI
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- Mysql 5.5 原始碼安裝後建立使用者報錯"ERROR 1045 (28000): Access denied for user"MySql原始碼Error
- tidb Error: Operation aborted by user answer '' (cliutil.operation_aborted)TiDBError
- 詳解oracle使用者建立(create user)(下)Oracle
- 詳解oracle使用者建立(create user)(上)Oracle
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- MySQL 5.6修復從庫複製時報錯'ERROR 1872 (HY000): Slave failed to initialize'MySqlErrorAI
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- MySQL5.6:mysql_secure_installation 報錯ERROR 2002 (HY000)MySqlError
- ubuntu下pig報錯ERROR 2999: Unexpected internal error. Failed to create DataStorage的解決UbuntuErrorAIAST
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- Connection to x as user y failed: ERROR: Wrong password for userAIError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- weblogic報錯: OPatch failed with error code 73WebAIError
- JBAS014613: Operation ("add") failed啟動報錯AI
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- svn報錯cleanup failed–previous operation has not finished; run cleanup if it was interrupte...AI
- ElasticSearch啟動報錯 ERROR: [4] bootstrap checks failedElasticsearchErrorbootAI
- MYSQL SOURCE報錯 ERROR: ASCIIMySqlErrorASCII
- Percona MySQL 5.6 語句加鎖報錯"ERROR 1665 (HY000): Cannot execute statement"MySqlError
- Laravel NO_AUTO_CREATE_USER 錯誤Laravel
- 一看便知linux下mysql報錯ERROR 1044: Access denied for user: '@localhost' to database 'mysql'LinuxMySqlErrorlocalhostDatabase
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- MySQL 登入資料庫報錯'ERROR 1045 (28000): Access denied for user'..'@'localhost''MySql資料庫Errorlocalhost
- mysql報錯ERROR 1093MySqlError
- super許可權報錯:ERROR1221(HY000):IncorrectusageofDBGRANTandGLOBALPRIVILEGESError
- 【ERROR】su user報'This account is currently not available'錯誤 for linuxErrorAILinux
- ERROR [main] zookeeper.RecoverableZooKeeper: ZooKeeper create failed after 4 attemptsErrorAI
- dbca建立資料庫時報錯ORA-13516: AWR Operation failed: CATPROC not valid資料庫AI
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- android模擬器 一個錯誤:X Error of failed request: BadRequest (invalid request code or no such operation)...AndroidErrorAI