解決Error (1133): Can’t find any matching row in the user table
解決Error (1133): Can’t find any matching row in the user table
mysql>GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY '' WITH GRANT OPTION;
Error (1133): Can’t find any matching row in the user table
解決方法
就是把小寫功能給關掉,這裡讓我饒不少彎路。在這此我特意記錄下來分享
在/etc/my.cnf 中的[mysqld]後新增新增lower_case_table_names=1,重啟MYSQL服務設定成功
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29065182/viewspace-1368646/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- Supervisor 解決 can't find command *
- 解決can't find -lGL的問題
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- cordova 解決can’t not find moudle " plugman platform ios"PlatformiOS
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- mysql can't connect error about privilege----not root userMySqlError
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- "Error: Can't find libjava.so" 9.2.0.4 on RH 4.0 x86-64ErrorJava
- user management table and t-code
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- eslint --fix 報錯 can't not find modulesEsLint
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- 解決ERROR 1231 (42000): Variable 'time_zone' can'tError
- Cannot find SS.INI file for user *** 解決方法
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- Linux下安裝Oracle 錯誤解決 - Error: Can't open display:127.0..0.1:0.0LinuxOracleError
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- master bug InnoDB Error unlock row could not find a 4 mode lockASTError
- You can‘t specify target table ‘Person‘ for update in FROM clause
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- mysql中You can’t specify target table for update in FROM clMySql
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- Can't find keyplane that supports type 4 for keyboard iPhone PortraitTiPhoneAI
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- can't assign requested address 錯誤解決
- linux上“rman can't open target”問題解決Linux
- ?Error: Can't locate /etc/centreon/conf.pm in @INC (@INError
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- Mysql:Variable 'XXXt' can't be set to the value of 'NULL'解決MySqlNull
- 解決問題:Variable 'time_zone' can't be set to the value of 'NULL'Null
- FileZilla:425 Can't open data connection for transfer of解決辦法
- mysql:Variable 'character_set_client' can't be set to the value of 'NULL'解決MySqlclientNull
- FATAL ERROR: Could not find ./bin/my_print_defaults 解決方法Error
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer