ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
来源:互联网 发布:大数据应用软件 编辑:程序博客网 时间:2024/05/18 18:20
使用MySQL命令行新建用户时出现
mysql> insert into mysql.user(Host,User,Password) values(‘localhost’,’aaaa’,password(123456’));
ERROR 1364 (HY000): Field ‘ssl_cipher’ doesn’t have a default value
原因:在我的配置文件my-default.ini中有这样一条语句
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
指定了严格模式,为了安全,严格模式禁止通过insert 这种形式直接修改mysql库中的user表进行添加新用户
解决办法:
将配置文件中的STRICT_TRANS_TABLES删掉,即改为:
sql_mode=NO_ENGINE_SUBSTITUTION
然后重启mysql即可
0 0
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- 创建用户报错ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- MySQL添加新用户 出现mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- MySQL创建用户 :ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql创建用户报错ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- Field 'ssl_cipher' doesn't have a default value
- Field 'ssl_cipher' doesn't have a default value
- ERROR 1364 (HY000): Field 'id' doesn't have a default value
- 解决Field 'ssl_cipher' doesn't have a default value的问题(mysql创建用户名和密码)
- deltav 安装过程
- Android屏幕适配全攻略(最权威的官方适配指导)
- app启动速度阶段指标
- javaweb读取配置文件的4种方法
- 21个实用的Javascript数据图表插件
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- OpenStack Newton 新功能介绍
- 去掉前面的和中间的数字
- fileupload和cos文件上传技术区别
- 说说JSON和JSONP,也许你会豁然开朗,含jQuery用例
- 文章标题
- 利用PLSQL创建定时任务
- serdes简介
- springmvc4使用websocket