【mysql报错】mysqld --initialize-insecure初始化时报错

aoeh

已于 2023-03-28 21:20:23 修改

阅读量3k

点赞数 7

文章标签： mysql 数据库

于 2023-03-28 21:19:39 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_43821215/article/details/129825385

版权

在尝试初始化MySQL8.0.32时，遇到了一个错误，涉及设置strict_trans_tables,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION到sql_mode。同时，服务器还报告了对dataLAPTOP-N36HO203.err文件的权限被拒绝，导致数据目录不可用。为了解决这个问题，用户从mysql配置文件my.ini中删除了相关语句，从而成功解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题

在初始化mysql时，出现这个错误

2023-03-28T13:08:29.258730Z 0 [Note] [MY-013847] [Server] Using jemalloc.dll for my_malloc and ut::malloc etc.
2023-03-28T13:08:29.286368Z 0 [ERROR] [MY-000077] [Server] E:\mysql\mysql-8.0.32-winx64\bin\mysqld.exe: Error while setting value 'STRICT_TRANS-TABLES,NO_ZERO_IN_DATE,NO-ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
2023-03-28T13:08:29.286535Z 0 [ERROR] [MY-010187] [Server] Could not open file 'data\LAPTOP-N36HO203.err' for error logging: Permission denied
2023-03-28T13:08:29.287049Z 0 [ERROR] [MY-013236] [Server] The designated data directory data is unusable. You can remove all files that the server added to it.
2023-03-28T13:08:29.287386Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-03-28T13:08:29.287534Z 0 [Note] [MY-010120] [Server] Binlog end