ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
来源:互联网 发布:360 卫士 for mac 编辑:程序博客网 时间:2024/05/18 21:10
今天在mysql (版本:5.6.21)中新增用户报了以下的错误:
"root@localhost 03:28:24 [mysql]>insert user(user,host,password) values('root','192.168.220.130','root');ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
但是查看表 user 并没有 ssl_cipher 这个列,原来是在这个版本中不能这样添加用户,
使用下面的命令可以顺利添加用户:
"root@localhost 03:29:43 [mysql]>GRANT USAGE ON *.* TO 'root'@'192.168.220.130' IDENTIFIED BY 'root' WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)
阅读全文
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创建用户名和密码)
- 根据屏幕大小来创建布局
- 解决Too many open files问题
- openstack plugin 之(八)怎样修改 Openstack Horizon(Dashboard)的显示界面
- 博客开通
- iOS开发学习笔记之UIButton的使用
- ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- Struts2的模型驱动(ModelDriven)
- BZOJ 3190 [JLOI2013] 赛车
- iOS 开发的资源整理
- Linux下安装Apache Http Server 的配置+一些错误信息的解决方法
- 带花树算法
- openstack plugin 之(九)怎样修改 Openstack Horizon(Dashboard)的显示界面
- Oracle 中 check约束
- git