MySQL异常:TIMESTAMP with implicit DEFAULT value is deprecated
来源:互联网 发布:db2导入数据库命令 编辑:程序博客网 时间:2024/05/29 11:33
问题:
D:\software\mysql\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>mysqld --initialize
2017-12-13T07:08:35.613357Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-13T07:08:35.615357Z 0 [ERROR] -- --initialize specified but the data directory has files in it. Aborting..
2017-12-13T07:08:35.616357Z 0 [ERROR] Aborting
原因:data文件夹已经存在
解决办法:删除该bin目录下的该文件夹,删除后重新执行该命令该文件夹会重新生成(如果删除不了可以下载文件粉碎机进行粉碎)
阅读全文
0 0
- MySQL异常:TIMESTAMP with implicit DEFAULT value is deprecated
- TIMESTAMP with implicit DEFAULT value is deprecated
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
- MySQL命令行启动报错[Warning] TIMESTAMP with implicit DEFAULT value is deprecated
- MySQL 5.6 中TIMESTAMP with implicit DEFAULT value is deprecated错误
- [Warning] TIMESTAMP with implicit DEFAULT value
- mysql的Invalid default value for 'timestamp'"错误解决
- mysql 5.7 invalid default value for timestamp field
- 【FAQ】mysql 初始化 timestamp,提示 Invalid default value for 'xxx'
- warning: push.default is unset; its implicit value is changing in
- MySQL:‘–default-character-set’ is deprecated 错误解决方法
- warning: push.default is unset; its implicit value has changed in Git 2.0 from 'matching' to 'simple
- Invalid default value for 'create_date' timestamp field
- Invalid default value for 'create_date' timestamp field
- MYSQL错误TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE的解决方案
- Android 6.0 动态权限申请注意事项
- dlib python人脸检测 特征点定位
- 解决过拟合的方式(一):正则化
- 量化投资的线性回归
- hjr教程-JAVA(三):多线程
- MySQL异常:TIMESTAMP with implicit DEFAULT value is deprecated
- mysql修改字段长度命令
- spring mvc dubbo整合cms内容发布平台
- 蓝桥杯试题——区间K大数查询
- Android 源码分析 —— 从 Toast 出发
- 36计详解
- mysql分组取每组前几条记录(排名) 附group by与order by的研究
- java相关知识
- js\jquery基础知识(一)