MYSQL启动失败，Can‘t create test file

管理员运行命令行，执行命令“net start mysql”，提示mysql服务无法启动，奇了怪了哈。

查看日志 输入“mysqld --console”，

2020-09-17T06:10:20.399528Z 0 [System] [MY-010116] [Server] C:\mysql\mysql-8.0.19\bin\mysqld.exe (mysqld 8.0.19) starting as process 2484
2020-09-17T06:10:20.401457Z 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.
2020-09-17T06:10:20.402210Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\mysql\mysql-8.0.19\data\mysqld_tmp_file_case_insensitive_test.lower-test
2020-09-17T06:10:20.402245Z 0 [Warning] [MY-010091] [Server] Can't create test file D:\mysql\mysql-8.0.19\data\mysqld_tmp_file_case_insensitive_test.lower-test
2020-09-17T06:10:20.402390Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'D:\mysql\mysql-8.0.19\data\' (OS errno: 2 - No such file or directory)
2020-09-17T06:10:20.429112Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-17T06:10:20.429233Z 0 [System] [MY-010910] [Server] C:\mysql\mysql-8.0.19\bin\mysqld.exe: Shutdown complete (mysqld 8.0.19)  MySQL Community Server - GPL.

 “Can't create test file D:\mysql\mysql-8.0.19\data\mysqld_tmp_file_case_insensitive_test.lower-test”

一般出现这种就是data文件夹的问题，删除掉，重新初始化，命令行输入

mysqld --initialize-insecure

重新启动mysql

C:\mysql\mysql-8.0.19\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。