下面的mysql服务开启是不是有问题？

 

有报错的，

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

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

 

  1. 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

  2. 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.

  3. 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

  4. 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

  5. 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)

  6. 2020-09-17T06:10:20.429112Z 0 [ERROR] [MY-010119] [Server] Aborting

  7. 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

 

  1. C:\mysql\mysql-8.0.19\bin>net start mysql

  2. MySQL 服务正在启动 .

  3. MySQL 服务已经启动成功