无法启动MySQL服务器(windows)

Question

我刚刚第一次安装了MySQL，在启动服务器时遇到了问题。这就是我尝试启动服务器的方式：

mysqld --console

这是输出：

2021-02-06T13:14:22.471410Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.23) starting as process 5272
2021-02-06T13:14:22.473472Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2021-02-06T13:14:22.473529Z 0 [Warning] [MY-010091] [Server] Can't create test file C:\Program Files\MySQL\MySQL Server 8.0\data\mysqld_tmp_file_case_insensitive_test.lower-test
2021-02-06T13:14:22.473661Z 0 [ERROR] [MY-013276] [Server] Failed to set datadir to 'C:\Program Files\MySQL\MySQL Server 8.0\data\' (OS errno: 2 - No such file or directory)
2021-02-06T13:14:22.485955Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-06T13:14:22.486053Z 0 [System] [MY-010910] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.

我该如何解决这个问题呢？

Answer 1

您尚未设置my.ini文件，以便MySQL知道在哪里可以找到所有路径。

在默认目录中，您没有写入权限

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" MySQL80

在该my.ini中，您可以找到

# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data

Mysql有写权限