原因：在我的配置文件my.cnf中有这样一条语句
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
指定了严格模式，为了安全，严格模式禁止通过insert 这种形式直接修改mysql库中的user表进行添加新用户
解决办法：
将配置文件中的STRICT_TRANS_TABLES删掉，即改为：
sql_mode=NO_ENGINE_SUBSTITUTION
然后重启mysql即可
相关文章
- ERROR: Field 'PostId' doesn't have a default value Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not execute statement
- mybatis向mysql数据库中插入数据报错Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value问题解决方法
- Field 'id' doesn't have a default value
- java.sql.SQLException: Field 'name' doesn't have a default value
- Field 'id' doesn't have a default value
- Field 'id' doesn't have a default value错误解决方法
- MySQL之Field‘***’doesn’t have a default value错误解决办法
- Field 'id' doesn't have a default value
- hibernate：Field 'id' doesn't have a default value 原因