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即可
No Comments