OS : linux redhat 6.4_x86 DB: mysql 5.6.21 64bit source PACK
mysql> insert into user(host,user,password) values("192.168.4.123","lmocm",password("1234"));
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
linux版本是my.cnf,一般会放在/etc/my.cnf,/etc/mysql/my.cnf
win下的是my.ini,一般会在安装目录的根目录