--initialize specified but the data directory has files in it. Aborting. 问题解决

最新推荐文章于 2024-03-20 19:58:06 发布

原创最新推荐文章于 2024-03-20 19:58:06 发布 · 6.7k 阅读 ·

本内容遵循CC 4.0 BY-SA版权协议

0nePiece

关注

标签

#mysql

分类数据库

收录于

bug解决专栏收录该内容

5 篇文章

订阅专栏

文章描述了在尝试初始化MySQL数据库时遇到的一系列警告和错误，包括关于timestamp默认值的提示、SQL模式设置以及因数据目录残留导致的初始化失败。作者提到原MySQL未完全删除，解决方法是清理数据目录并调整my.ini配置。

在这里插入图片描述
当电脑输入这条命令以试图初始化数据库的时候，出现这样的错误。

2023-10-23T09:04:21.258180Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-10-23T09:04:21.258237Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2023-10-23T09:04:21.258241Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2023-10-23T09:04:21.260667Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2023-10-23T09:04:21.261250Z 0 [ERROR] Aborting