我刚刚第一次安装MySQL，并且在启动服务器时遇到问题。这是我试图启动服务器的方式:
mysqld --console
，这是输出:
2021-02-06T13:14:22.471410Z 0 [System] [MY-010116] [Server] C:Program FilesMySQLMySQL Server 8.0binmysqld.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 FilesMySQLMySQL Server 8.0datamysqld_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 FilesMySQLMySQL Server 8.0datamysqld_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 FilesMySQLMySQL Server 8.0data' (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 FilesMySQLMySQL Server 8.0binmysqld.exe: Shutdown complete (mysqld 8.0.23) MySQL Community Server - GPL.
我该如何解决这个问题?
您没有设置my.ini文件，以便MySQL知道在哪里找到所有路径。
默认目录中没有写权限
"C:Program FilesMySQLMySQL Server 8.0binmysqld.exe" --defaults-file="C:ProgramDataMySQLMySQL Server 8.0my.ini" MySQL80
在my.ini中你可以找到
# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 8.0/Data
Mysql有写权限