Unable to start the MySQL service "1067 process unexpected termination" solution--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's a summary of a number of workarounds that cause the MySQL prompt to fail to start the MySQL service "1067 process unexpected termination". I encountered this problem is to check a lot of methods do not, and finally see a discussion forum. Tried it and actually could. is part of the online approach. The last thing I can do is put it 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) "to see if the MySQL service is not dependent on the other, then suddenly thought into the system log to see. Sure enough, I found a lot of MySQL bugs and found the problem.

Open the MySQL service prompt in Win7 server "Windows cannot start the MySQL service (located on the local computer.) Error 1067: Process terminated unexpectedly) " a solution to the method oneGo to "Event Viewer" "Application" and find out very much MySQL error default storage engine (InnoDB) is not availableso into the MySQL installation folder found My.ini There is a sentence: Default-storage-engine=innodb changed to MyISAM can be. Turn on the MySQL service now and you'll be able to open it successfully.

Workaround for two

When you reload MySQL, you always notice that the MySQL service cannot be started. Error 1067 process terminated unexpectedly
Reboot. It's no use repairing the register,
On-line check. It's useless to change any basedir.
I'm using a mysql5.8,
Look for them. Think of the wampserver,pc_webserver and other integrated environments,
The software writes My.ini, php.ini to the C:windows folder and is set to read-only

Workaround:

Remove the My.ini file from the Windows folder.

Reload MySQL, service started successfully ...

three ways to solve the problem

1, running 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 the Mysql-u root-p connection, look at the server service. It is true that the MySQL service is not started. Manual start generates a 1067 error. Once again, I've installed MySQL a few times and it's still wrong. No errors are observed for each configuration.

My system environment Win2003 MySQL version number 4.0.12.

The method to be resolved. Copy the winmysqladmin generated My.ini to c:windows and start MySQL and everything is OK.

This has not been tried: in fact, there is no need to configure again you just have to click Mysql.exe in the/bin folder

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.

Workaround for 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 ". The seven or eight floor method is not to add my.ini files, but on the original my-default.ini to make changes. Original replies such as the following:

"My MySQL version number is 5.6.12, after decompression. Create the My.ini file as you said online, as you did. Also encountered the problem you have encountered. Can't find the answer, it's going crazy.
Then think about it, why not bring your own my-default.ini.

Then remove the My-default.ini in the # gaze configuration.

CMD under execution:
Mysqld.exe--install
net start MySQL
Success!

！

”

Thinking about the question notice the beginning of the article Baidu experience in the "third big step: Configure the default file," said: "In fact, the theory is now able to install the service directly, but because it is the default configuration." There are a lot of problems when we use them. For example, the Chinese characters are all garbled or something, so it is recommended that you configure the default files first.

In the mysql-x.x.xx-winx64 (small part is 5.6.17 according to their own version number) folder, create a new My.ini. Copy the following code to save it OK. My.ini will replace the following My-default.ini file.

"The solution is a temporary one, but there are a lot of problems behind it." Then we'll take a look at it, and then you can't do it again. The perfectionist really spends a lot of time.

Simple to use or should not be too much of a problem!

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