ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
解決辦法:開啟my.ini,查詢
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
修改為
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
然後重啟MYSQL
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1443600/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL5.6新增root使用者報錯:Field 'ssl_cipher' doesn't have a default valueMySql
- 資料庫報錯java.sql.SQLException: Field ‘id‘ doesn‘t have a default value資料庫JavaSQLException
- Field ‘spu_id‘ doesn‘t have a default valu 解決辦法
- 安裝mysql遇到ERROR: 1136 Column count doesn't match value count at row 1MySqlError
- 解決pgpool啟動報錯 ifup[/sbin/ip] doesn't have setuid bitUI
- 'mysql.column_stats' doesn't exist and Table 'mysql.index_stats' doesn't existMySqlIndex
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist解決辦法ErrorMySql
- scrollTop doesn't scroll on Chrome 61Chrome
- C++ doesn't name a typeC++
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- MySQL ERROR 1366(HY000):Incorrect string value:''for column''at row 1解決方案MySqlError
- MySQL 亂碼實戰解決ERROR 1366 (HY000): Incorrect string value: 'MySqlError
- yebis error ---depth of fieldError
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- 函式引數的 Default value函式
- doesn't contain a valid partition tableAI
- Solaris 5.8 CRON doesn't work with regular user
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- about Res folder doesn't exist in android projectAndroidProject
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- lower_case_table_names引數設定解決Error Code: 1146. Table doesn't exist?Error
- d3d11 effect state and default value tables3D
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- 網站提示:You Don’t Have Permission To Access網站
- if doesn't support the "condition"attribute 問題解決
- MySQL查詢報錯:ERROR 1146 (42S02): Table 'craw.sitePageConfig' doesn't existMySqlError
- Couldn't be opened because you don't have permission to view it 執行時報錯View
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress