win10安装mysqld 8.0.13时候报错， mysqld --initialize --console

[蔚蓝追风鹅]

D:\mysql-8.0.13-winx64\bin>mysqld --initialize --console
2018-12-01T08:57:50.209734Z 0 [System] [MY-013169] [Server] D:\mysql-8.0.13-winx64\bin\mysqld.exe (mysqld 8.0.13) initializing of server in progress as process 4128
2018-12-01T08:57:50.211323Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2018-12-01T08:57:50.215088Z 0 [ERROR] [MY-013236] [Server] Newly created data directory D:\mysql-8.0.13-winx64\data\ is unusable. You can safely remove it.
2018-12-01T08:57:50.216564Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-12-01T08:57:50.217891Z 0 [System] [MY-010910] [Server] D:\mysql-8.0.13-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.13) MySQL Community Server - GPL.

[学海无涯-回头是岸]

datas 文件夹 非空

[蔚蓝追风鹅]

引用 1 楼 学海无涯回头是岸_ 的回复:

datas 文件夹 非空

请问下是data必须新建一个空的目录还是，不用建空目录，不过我都试过了，还是报错呢，报错后data文件夹里就自动生成许多文件了

[qq_16105853]

检查下配置文件my.ini里面的basedir和datadir路径有没错~

[qq_16105853]

https://blog.csdn.net/m0_37461416/article/details/78680627看看这个

[ZOUZDC]

根据我的经验: 你初始化的时候,没有指定配置文件,可能导致,mysql自己去其他地方扫描出了一个my.inf文件或者用默认的配置初始化mysql, 在我测试的时候当配置文件中包含过多的命令的时候或者多个不相关的命令顺序不对的时候就可能初始化失败. 你可以用一下的流程试一下 my.ini文件内容 ``` [mysql] default-character-set=utf8 [mysqld] default-storage-engine=INNODB basedir=D:/WorkProgramFiles/mysql-8.0.13x64 #程序根目录 datadir=F:/ProgramFilesData/mysql-8.0.13x64Data #想要存储数据的文字,不存在则创建,但是该文件中有内容则报错 ``` 在muysql/bin中启动命令行,输入命令 ··· mysqld.exe --defaults-file="D:/WorkProgramFiles/mysql-8.0.13x64/my.ini" --initialize --console ··· 其中"D:/WorkProgramFiles/mysql-8.0.13x64/my.ini"替换为你的my.inf地址 basedir和datadir地址为/

[布噜布噜bulubulu]

D:\mysql-8.0.15-winx64\bin>mysqld --initialize --console 2019-04-12T13:14:52.703863Z 0 [System] [MY-013169] [Server] D:\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 15888 2019-04-12T13:14:57.857572Z 0 [ERROR] [MY-000068] [Server] unknown option '--UTF8'. 2019-04-12T13:14:57.857581Z 0 [Warning] [MY-010952] [Server] The privilege system failed to initialize correctly. If you have upgraded your server, make sure you're executing mysql_upgrade to correct the issue. 2019-04-12T13:14:57.857594Z 0 [ERROR] [MY-013236] [Server] Newly created data directory D:\mysql-8.0.15-winx64\Data\ is unusable. You can safely remove it. 2019-04-12T13:14:57.871197Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-04-12T13:14:59.126320Z 0 [System] [MY-010910] [Server] D:\mysql-8.0.15-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL. 这个怎么解决啊

[lsh2245448]

mysqld: Can't create directory 'C:\web\mysql-8.0.11\data\' (OS errno 2 - No such file or directory) 2019-04-23T08:36:17.031874Z 0 [System] [MY-013169] [Server] C:\Program Files\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 11704 2019-04-23T08:36:17.032077Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'C:\web\mysql-8.0.11\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. 2019-04-23T08:36:17.033268Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2019-04-23T08:36:17.036756Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\web\mysql-8.0.11\data\ is unusable. You can safely remove it. 2019-04-23T08:36:17.068228Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-04-23T08:36:17.068495Z 0 [System] [MY-010910] [Server] C:\Program Files\mysql-8.0.15-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.

[lsh2245448]

mysqld: Can't create directory 'C:\Program Files\mysql-8.0.15-winx64\data\' (OS errno 13 - Permission denied) 2019-04-23T08:40:54.838393Z 0 [System] [MY-013169] [Server] C:\Program Files\mysql-8.0.15-winx64\bin\mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 9716 2019-04-23T08:40:54.841184Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. 2019-04-23T08:40:54.844094Z 0 [ERROR] [MY-013236] [Server] Newly created data directory C:\Program Files\mysql-8.0.15-winx64\data\ is unusable. You can safely remove it. 2019-04-23T08:40:54.864646Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-04-23T08:40:54.864951Z 0 [System] [MY-010910] [Server] C:\Program Files\mysql-8.0.15-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.

[Hi船长]

ini配置文件路径配置错误就有这问题。

[江湖人称小鱼哥]

只需要把data文件夹删除就好了，对这群人醉了，五花八门

[江湖人称小鱼哥]

引用 10 楼 石门美美哒 的回复:

ini配置文件路径配置错误就有这问题。

你到底有没有碰到这个错误啊

[「已注销」]

zou 成功了 感谢

[weixin_45501964]

mysqld: Can't create/write to file 'Disaibao\mysql-8.0.11-winx64\mysql-8.0.11-winx64\data\is_writable' (OS errno 2 - No such file or directory)
2019-10-16T05:59:23.549006Z 0 [System] [MY-013169] [Server] D:\bisaibao\mysql-8.0.11-winx64\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 18064
2019-10-16T05:59:23.549101Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file 'D:\bisaibao\mysql-8.0.11-winx64\mysql-8.0.11-winx64\binisaibao\mysql-8.0.11-winx64\mysql-8.0.11-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2019-10-16T05:59:23.552782Z 0 [ERROR] [MY-010460] [Server] --initialize specified but the data directory exists and is not writable. Aborting.
2019-10-16T05:59:23.582908Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-16T05:59:23.586735Z 0 [System] [MY-010910] [Server] D:\bisaibao\mysql-8.0.11-winx64\mysql-8.0.11-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.
我的要怎么解决阿

[lgrason]

把 D:\mysql-8.0.13-winx64\data\ 里面的东西删掉，再执行mysqld --initialize

[request_getAttribute]

应该是你的my.ini有问题了，像我刚刚才发现折磨了我半天的东西，其实只是我在改my.ini文件的时候一不小心把注释给去了，导致mysql无法初始化

[zanxinshiyao]

mysqld: Can't create/write to file 'D:\java\mysql-8.0.19-winx6in\is_writable' (OS errno 2 - No such file or directory)
2020-02-18T05:53:15.240223Z 0 [System] [MY-013169] [Server] D:\java\mysql-8.0.19-winx64\bin\mysqld.exe (mysqld 8.0.19) initializing of server in progress as process 9180
2020-02-18T05:53:15.244347Z 0 [ERROR] [MY-010460] [Server] --initialize specified but the data directory exists and is not writable. Aborting.
2020-02-18T05:53:15.244369Z 0 [ERROR] [MY-013236] [Server] The designated data directory D:\java\mysql-8.0.19-winx6in\ is unusable. You can remove all files that the server added to it.
2020-02-18T05:53:15.266169Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-02-18T05:53:15.269267Z 0 [System] [MY-010910] [Server] D:\java\mysql-8.0.19-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.19) MySQL Community Server - GPL.
这个应该怎么解决啊 求指教

[zanxinshiyao]

也没有data文件夹啊