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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 1364 - Field did doesnt have a default value
- 資料庫報錯java.sql.SQLException: Field ‘id‘ doesn‘t have a default value資料庫JavaSQLException
- Field ‘spu_id‘ doesn‘t have a default valu 解決辦法
- 解決pgpool啟動報錯 ifup[/sbin/ip] doesn't have setuid bitUI
- 錯誤訊息 This computer doesn't have VT-X/AMD-v enabled
- pymysql.err.OperationalError: (1136, “Column count doesn‘t match value count at row 1“)報錯反省。MySqlError
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- ERROR 1114 (HY000) The table '' is fullError
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- 115 svn: URL 'svn://132.232.108.38/think' doesn't exist
- ERROR 1290 (HY000) 解決辦法Error
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- Syntax error, unrecognized expression: li[value=]ErrorZedExpress
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- adb連線失敗報錯“AdbProcess::error:adb server version (32) doesn‘t match this client (41); killing...”的修復ErrorServerclient
- PostgreSQL DBA(115) - pgAdmin(Don't do this:Don't use varchar(n) by default)SQL
- 網站提示:You Don’t Have Permission To Access網站
- 如何解決"You have an error in your SQL syntax"ErrorSQL
- error: invalid type argument of unary ‘*‘ (have ‘int‘) *__first = __tmp;Error
- mysql 報錯:ERROR 1366 (HY000): Incorrect string value: ‘\xD5\xC5\xC8\xFD‘ for column ‘name‘ at row 1MySqlError
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- 屬性font-family:Font property font-family does not have generic default
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- SAP MRKO Error - For document type RE, an entry is required in field Reference -ErrorUI
- Error creating bean with name ‘dataSource‘: Unsatisfied dependency expressed through fieldErrorBeanExpress
- MongoDB server returned error on SASL authentication step: BSON field 'saslCoMongoDBServerError
- You don't have write permissions for the /usr/bin directory.
- mysql遇到Variable can’t be set to the value of ‘NULL’MySqlNull
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- 2018 icpc徐州站網路賽 H Ryuji doesn't want to study
- [Vue warn]: The data property "dialogVisible" is already declared as a prop. Use prop default valueVue
- mysql-timestamp 0000-00-00 00:00:00 Invalid default valueMySql
- 萬能方法解決——You have an error in your SQL syntaxErrorSQL
- 阿里雲mysql遠端登入報ERROR 2027(HY000)阿里MySqlError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer