问题
在初始化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 denied2023-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] Aborting2023-03-28T13:08:29.287534Z 0 [Note] [MY-010120] [Server] Binlog end
解决办法:
在mysql配置文件my.ini中把下面这句话删除就可以解决了
成功
来源地址:https://blog.csdn.net/weixin_43821215/article/details/129825385