windows下启动MySQL8报错...

最新推荐文章于 2024-07-12 14:57:26 发布

分享使我快乐

最新推荐文章于 2024-07-12 14:57:26 发布

阅读量941

点赞数

分类专栏：数据库文章标签： windows java mysql

本文链接：https://blog.csdn.net/common_heart/article/details/127873244

版权

在Windows上启动MySQL8时遇到错误，原因是启动参数格式错误导致无法设置datadir。通过修正启动命令，即在参数前加上等号，成功解决了启动问题，并展示了正确启动的输出日志。

摘要由CSDN通过智能技术生成

报错输出

C:\Users\demo>mysqld --defaults-file C:\Users\demo\Documents\my.ini --console
2022-11-15T12:23:44.882499Z 0 [System] [MY-010116] [Server] D:\mysql\bin\mysqld.exe (mysqld 8.0.31) starting as process 23772
2022-11-15T12:23:44.884515Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\mysql\data\mysqld_tmp_file_case_insensitive_test.lower-test
2022-11-15T12:23:44.884604Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\mysql\data\mysqld_tmp_file_case_insensitive_test.lower-test
2022-11-15T12:23:44.884764Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'D:\mysql\data\' (OS errno: 2 - No such file or directory)
2022-11-15T12:23:44.885182Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-11-15T12:23:44.885301Z 0 [System] [MY-010910] [Server] D:\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.31) MySQL Community Server - GPL.

原启动命令