Unable to start the MySQL service "1067 process unexpected termination" workaround--Summary and the ultimate method

I began to follow the Baidu experience in the method-"MySQL download installation, configuration and use (win7x64)" To install and configure, but to the next step always appear 1067 code-name error. Slowly toss to solve.
Here is a summary of a variety of solutions that cause the MySQL prompt to fail to start the MySQL service "1067 process unexpected termination". Oneself encountered this problem is to check a lot of ways not, finally see a forum discussion, tried a bit unexpectedly can. is a part of the online method, the last possible way I put on the last side:
When you enable the MySQL service, Windows cannot start the MySQL service (located on the local computer. Error 1067: The process terminated unexpectedly) "Look at the MySQL service and there is no other dependent Ann Ah, so suddenly thought into the system log to see, sure enough to find a lot of MySQL errors, and finally found the problem.

Turn on the MySQL service prompt on the win7 server "Windows cannot start the MySQL service (located on the local computer.) Error 1067: Process terminated unexpectedly) " Workaround OneGo to "Event Viewer" "Application" did find a lot of MySQL error default storage engine (InnoDB) is not availableso into the MySQL installation directory to find My.ini There is a sentence: Default-storage-engine=innodb changed to MyISAM on it. Start the MySQL service right away and you'll be able to open it.

Solution Two

"Unable to start MySQL service, error 1067 process terminated unexpectedly" when reloading MySQL
Restart, repair the registry is useless,
Online Search, change what basedir, also useless
I'm using a mysql5.8,
Look for, think of before the integration environment, such as Wampserver,pc_webserver,
The software writes My.ini, php.ini to the C:windows directory, and is set to read-only

Workaround:

Remove the My.ini file from the Windows directory,

Reload MySQL, service started successfully ...

Solution Three

1, execute winmysqladmin, generate My.ini file
2. Mysqld-install Start MySQL Service
3. net start MySQL start MySQL service display normal
When the server is not started by Mysql-u root-p connection error, look at Server service, do not start the MySQL service, manual start to produce 1067 errors, reinstall several times MySQL, error is still. No errors are observed for each configuration.

My system environment is win2003 MySQL version 4.0.12.
Workaround, copy the winmysqladmin generated My.ini to c:windows and start MySQL all OK.
This has not been tried: actually do not need to reconfigure you just click Mysql.exe in the/bin directory

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

When the cue box appears, cancle it out directly.

Then click on Winmysqladmin.exe to select the start service on the small icon on the right.

Solution Four

In fact, some of the above have been unsuccessful after the trial, and finally in a forum to see a post-"MySQL 5.6 greening Let me collapse." System error 1067 ". Of the seven or eight floor of the method is not new My.ini file, but in the original My-default.ini on the modification, replies are as follows:

"My MySQL version is 5.6.12, after decompression, press online to create the My.ini file, as you did." Also encountered the problem you encountered, can not find the answer, is going crazy.
Then think about it, why not bring your own my-default.ini. The configuration of the # annotations in My-default.ini is removed.
CMD under Run:
Mysqld.exe--install
net start MySQL
Success!!

”

Thinking about the question notice in the beginning of the article Baidu experience in the "third big step: Configure the default file," said: "In fact, in theory now you can install the service directly, but because it is the default configuration, we use the time there will be a lot of problems." For example, the Chinese characters are all garbled and so on, so it is recommended that you configure the default files first. In mysql-x.x.xx-winx64 (small part of the 5.6.17 according to their own version) under the directory, create a new My.ini. Copy the following code to save the OK. My.ini will replace the following My-default.ini file. "That solution four, although temporarily resolved, but there will be a lot of problems later." Let's take a look at it, and then try to do it again in the way above, and the perfectionist does take a lot of time. Simple to use or should not be too much of a problem!

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Unable to start the MySQL service "1067 process unexpected termination" workaround--Summary and the ultimate method