MySQL 5.7.14 net start mysql service cannot be started-"net helpmsg 3534" strange problem, 5.7.143534

MySQL 5.7.14 net start mysql service cannot be started-"net helpmsg 3534" strange problem, 5.7.143534

My. ini

After reading http://www.bkjia.com/article/100284.htm

Error message displayed when executing mysqld -- initialize-insecure

C:\WINDOWS\system32>mysqld --initialize-insecure mysqld: Can't create directory 'D:\Program Files oft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\data\' (Errcode: 2 - No such file or directory) 2016-12-16T02:12:53.583901Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-12-16T02:12:53.583901Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2016-12-16T02:12:53.583901Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2016-12-16T02:12:53.583901Z 0 [ERROR] Can't find error-message file 'D:\Program Files oft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. 2016-12-16T02:12:53.583901Z 0 [ERROR] Aborting 

You have to change the directory to a backslash.

[Client] port = 3306 default-character-set = utf8 [mysqld] port = 3306 character_set_server = utf8 basedir = D: /Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64 # extract directory datadir = D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64/data # extract directory data SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES [WinMySQLAdmin] D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64/bin/mysqld.exe

Execution successful again

C:\WINDOWS\system32> mysqld install MySQL --defaults-file="D:\Program Files\soft\mysql-5.7.14-winx64\mysql-5.7.14-winx64\my.ini" Service successfully installed.  C:\WINDOWS\system32>net start mysql 

MySQL service is starting.

The MySQL service has been started successfully.

C:\WINDOWS\system32> 

The preceding section describes the strange problem that MySQL 5.7.14 net start mysql service cannot be started-"net helpmsg 3534". I hope it will be helpful to you, if you have any questions, please leave a message and the editor will reply to you in time. Thank you very much for your support for the help House website!