Windows installation MySQL 5.6 system error 1067

Problem:

#安装MySQL服务: Mysqld-install MySQL5

D:\Program Files\mysql_5.6.24_winx64\bin>mysqld-install MySQL5
Service successfully installed.

#启动MySQL服务: net start mysql5

D:\Program files\mysql_5.6.24_winx64\bin>net Start MySQL5
MySQL5 Service is starting ...
The MYSQL5 service could not be started.

System error.

System error 1067 has occurred.

The process terminated unexpectedly.

#卸载MySQL服务: SC Delete mysql5
D:\Program FILES\MYSQL_5.6.24_WINX64\BIN>SC Delete MySQL5
[SC] DeleteService success

Solution Ideas:

1. Search for exception information:MySQL has a system error 1067, find the following workaround

2. View the Event Manager: Refer to the following links

How Windows opens and manages computers by using Event Viewer

Http://jingyan.baidu.com/article/0964eca23201c88285f53604.html

Search for specific exception information:Can ' t find messagefile ' D:\Program files\mysql-5.6.24-winx64\share\errmsg.sys '

This problem is due to the fact that MySQL cannot find the following corresponding boot file:

Defaults-file=/mysql/my.cnf

Basedir=/mysql

Datadir=mysql/data

--------------------------------------------------------------------------------

Think of your own configuration file My.ini

Source of the problem:

Open after sure path is not correct, set the Basedir and DataDir path with my decompression path inconsistent, the extracted path copy to avoid errors

# These is commonly set, remove the # and set as required.
#mysql root directory
basedir = "D:\Program files\mysql_5.6.24_winx64"
#mysql Data File storage directory
datadir = "D:\Program files\mysql_5.6.24_winx64\data"
# port = .....
# server_id = ...

---------------------------------------------------------------------------------

Installation Method Reference:

Http://www.cnblogs.com/freeton/p/4264829.html

Windows installation MySQL 5.6 system error 1067