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
展开