关于安装mysql时的带有隐含DEFAULT值的TIMESTAMP已被弃用的错误

卸载旧版本安装新版本mysql时,出现了以下错误

TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-11-23T07:13:01.046760Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2021-11-23T07:13:01.047739Z 0 [ERROR] Aborting

可以通过删除mysql目录下data文件夹,再以管理员身份打开cmd,重新初始化一下就可以解决

posted @ 2021-11-23 15:31  JiaMii  阅读(412)  评论(0)    收藏  举报