ZMX - IT技术交流论坛 - 无限Perfect，追求梦想 - itzmx.com

标题: 转：MySQL:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value [打印本页]

---

作者: 小樱    时间: 2015/12/9 21:05
标题: 转：MySQL:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
MySQL 5,Field 'id' doesn't have a default value 或者建立新用户时出现ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
解决办法：打开my.cnf，查找

1. sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

复制代码

修改为

1. sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

复制代码

然后重启MYSQL即可

出处：http://www.lastme.com/server/mysql/mysqlerror-1364-hy000-field-ssl_cipher-doesnt-have-a-default-value/

---

欢迎光临 ZMX - IT技术交流论坛 - 无限Perfect，追求梦想 - itzmx.com (https://bbs.itzmx.com/)

Powered by Discuz! X3.4