转：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/