小樱 发表于 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，查找
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

修改为
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/

页: [1]
查看完整版本: 转：MySQL:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value