mysql不安装在c_mysql 突然不行了 不想重新装 为什么要检查C:\Program Files\MySQL\MySQL Server 5.7\data\...

C:\ProgramFiles\MySQL\MySQLServer5.7\bin>mysqld-consolemysqld:Can'tchangedirto'C:\ProgramFiles\MySQL\MySQLServer5.7\data\'(Errcode:2-Nosuchfileordirectory)2016-11-02T05:0...

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld -console

mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory)

2016-11-02T05:02:55.239589Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

2016-11-02T05:02:55.239589Z 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.

2016-11-02T05:02:55.249589Z 0 [Note] mysqld (mysqld 5.7.9) starting as process 3896 ...

2016-11-02T05:02:55.249589Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\Mr_Xu-PC.lower-test

2016-11-02T05:02:55.249589Z 0 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Server 5.7\data\Mr_Xu-PC.lower-test

2016-11-02T05:02:55.249589Z 0 [ERROR] failed to set datadir to C:\Program Files\MySQL\MySQL Server 5.7\data\

2016-11-02T05:02:55.249589Z 0 [ERROR] Aborting

2016-11-02T05:02:55.249589Z 0 [Note] Binlog end

2016-11-02T05:02:55.249589Z 0 [Note] mysqld: Shutdown complete

我my.ini配置的是 C:\ProgramData\MySQL\MySQL Server 5.7\Data

展开