mysqld:不能将目录更改为数据。服务器无法启动

浏览:70日期:2024-01-16
如何解决mysqld:不能将目录更改为数据。服务器无法启动?

由于您使用Windows安装程序,因此一切都已设置为可将MysqL 5.7作为Windows服务运行,这在大多数情况下是一个不错的选择。

而不是MysqLd.exe从命令行运行,

Win + R跑 services.msc右键点击 MysqL57启动服务。解决方法

我使用安装程序安装了MySQL服务器,然后启动了该服务器。重新启动后,我尝试再次启动它并得到错误:

D:Program FilesMySQLMySQL Server 5.7bin>mysqld -u root -pmysqld: Can’t change dir to ’D:Program FilesMySQLMySQL Server 5.7data’ (Errcode: 2 - No such file or directory)2015-11-17T08:30:18.822962Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).2015-11-17T08:30:18.822962Z 0 [Warning] Insecure configuration for --secure- file -priv: Current value does not restrict location of generated files. Consider setting it to a valid,non-empty path.2015-11-17T08:30:18.822962Z 0 [Note] mysqld (mysqld 5.7.9) starting as process 1108 ...2015-11-17T08:30:18.838586Z 0 [Warning] Can’t create test file D:Program FilesMySQLMySQL Server 5.7dataDESKTOP-RNBR3E8.lower-test2015-11-17T08:30:18.838586Z 0 [Warning] Can’t create test file D:Program FilesMySQLMySQL Server 5.7dataDESKTOP-RNBR3E8.lower-test2015-11-17T08:30:18.838586Z 0 [ERROR] failed to set datadir to D:Program FilesMySQLMySQL Server 5.7data2015-11-17T08:30:18.838586Z 0 [ERROR] Aborting2015-11-17T08:30:18.838586Z 0 [Note] Binlog end2015-11-17T08:30:18.838586Z 0 [Note] mysqld: Shutdown complete

我试图重新安装MySQL。更新:当我mysqld -u root -p以管理员身份运行时,什么都没有发生。

相关文章: