各位用户为了找寻关于MySQL 5.7.14 net start mysql 服务无法启动-“NET HELPMSG 3534” 的奇怪问题的资料费劲了很多周折。这里教程网为您整理了关于MySQL 5.7.14 net start mysql 服务无法启动-“NET HELPMSG 3534” 的奇怪问题的相关资料,仅供查阅,以下为您介绍关于MySQL 5.7.14 net start mysql 服务无法启动-“NET HELPMSG 3534” 的奇怪问题的详细内容
my.ini
在参考http://www.zzvips.com/article/82191.html之后
执行mysqld --initialize-insecure出现错误提示
? 1 2 3 4 5 6 7C:WINDOWSsystem32>mysqld
--initialize-insecure
mysqld: Can
't create directory '
D:Program Files oftmysql-5.7.14-winx64mysql-5.7.14-winx64data
' (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 oftmysql-5.7.14-winx64mysql-5.7.14-winx64shareerrmsg.sys'
.
Check
error-message file location
and
'lc-messages-dir'
configuration directive.
2016-12-16T02:12:53.583901Z 0 [ERROR] Aborting
只好把目录改成反斜杠
? 1 2 3 4 5 6 7 8 9 10 11 12 13[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
#解压目录
datadir=D:/Program Files/soft/mysql-5.7.14-winx64/mysql-5.7.14-winx64/data
#解压目录下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
再次执行成功
? 1 2 3C:WINDOWSsystem32> mysqld install MySQL
--defaults-file="D:Program Filessoftmysql-5.7.14-winx64mysql-5.7.14-winx64my.ini"
Service successfully installed.
C:WINDOWSsystem32>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
? 1C:WINDOWSsystem32>
以上所述是小编给大家介绍的MySQL 5.7.14 net start mysql 服务无法启动-“NET HELPMSG 3534” 的奇怪问题,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!
原文链接:http://blog.csdn.net/ender__/article/details/53689804