mysqld: Can't change dir to 'D:\TONG\mysql-5.7.19-winx64\data\' (Errcode: 2

本文记录了一次MySQL 5.7.19版本在Windows环境下启动失败的问题排查过程。主要错误信息为无法更改目录到指定路径及无法创建测试文件等。通过对错误日志的分析，指出可能的原因包括路径配置不正确或命令输入有误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysqld: Can't change dir to 'D:\TONG\mysql-5.7.19-winx64\data\' (Errcode: 2 - No such file or directory)
2017-09-20T07:27:11.588451Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-09-20T07:27:11.588451Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2017-09-20T07:27:11.589449Z 0 [Note] mysqld (mysqld 5.7.19) starting as process 7216 ...
2017-09-20T07:27:11.592454Z 0 [Warning] Can't create test file D:\TONG\mysql-5.7.19-winx64\data\LAPTOP-APUL5GO0.lower-test
2017-09-20T07:27:11.593452Z 0 [Warning] Can't create test file D:\TONG\mysql-5.7.19-winx64\data\LAPTOP-APUL5GO0.lower-test
2017-09-20T07:27:11.595455Z 0 [ERROR] failed to set datadir to D:\TONG\mysql-5.7.19-winx64\data\
2017-09-20T07:27:11.609104Z 0 [ERROR] Aborting

2017-09-20T07:27:11.610105Z 0 [Note] Binlog end
2017-09-20T07:27:11.612108Z 0 [Note] mysqld: Shutdown complete

1　路径不对,

2　或者,命令没有打对

转载于:https://www.cnblogs.com/tongs/p/7561892.html