[ERR] 1231 - Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
在將mysql5.7匯出的.sql檔案執行在MySQL8上報標題錯誤。
原因:MySQL8取消了NO_AUTO_CREATE_USER
解決方案:把.sql檔案裡的 'NO_AUTO_CREATE_USER'刪掉就好了
相關文章
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- 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
- 解決ERROR 1231 (42000): Variable 'time_zone' can'tError
- 完美解決stack Error: Can‘t find Python executable “python“, you can set the PYTHON env variable.ErrorPython
- Caused by: org.apache.parquet.io.ParquetDecodingException: Can‘t read value in column [result, labelApacheException
- cannot access local variable where it is not associated with a value
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- 報錯:npm ERR! missing script: serve npm ERR! A complete log of this run can be found in:NPM
- 錯誤解決:Attempting to use uninitialized value VariableZed
- TypeError: can‘t concat str to bytesError
- Can't open file: (errno: 24)
- Supervisor 解決 can't find command *
- Mongoose can't update timestampGo
- 翻譯:SET Variable(已提交到MariaDB官方手冊)
- oracle 之 CLUSTER_INTERCONNECTS is not set to the recommended valueOracle
- eslint --fix 報錯 can't not find modulesEsLint
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- Can't load IA 32-bit .dll on a
- multiprocessing pool AttributeError: Can't get attribute 'func'Error
- Unknown initial character set index ‘255‘ received from server. Initial client character set can beIndexServerclient
- Python——UnicodeEncodeError: 'ascii' codec can't encode/decode charactersPythonUnicodeErrorASCII
- redis : Can't save in background: fork: Cannot allocate memoryRedis
- 4.WebStorm 建立vue專案,can not install ‘ij-rpc-client’/npm ERR!WebORMVueRPCclientNPM
- FILESTREAM feature can't be enabled if you use cluster shared volumes
- WIN配置git 配置後失敗 can't be establishedGit
- Error:Can't connect to SOCKS proxy:Connection refused (Connection refused)Error
- Python報錯:UnicodeDecodeError: 'gbk' codec can't decode byte ...PythonUnicodeError
- You can‘t specify target table ‘Person‘ for update in FROM clause
- Fatal error: can't check configuration file '/home/watt/proxy/dError
- python cx_Oracle: UnicodeEncodeError: 'ascii' codec can't encode charactersPythonOracleUnicodeErrorASCII
- why this draw call can‘t be batched with the previous one for Unity2019.4+BATUnity
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- mysql中You can’t specify target table for update in FROM clMySql
- Laravel NO_AUTO_CREATE_USER 錯誤Laravel
- @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty
- FileZilla:425 Can't open data connection for transfer of解決辦法
- 問題解決zipimport.ZipImportError: can‘t decompress data; zlib not availablImportErrorAI