Unable to start MySQL service "1067 process unexpected termination" solution

"Windows cannot start the MySQL service (located on the local computer) when the MySQL service is enabled." Error 1067: Process terminated unexpectedly) ", look at the MySQL service and there is no other reliance on Ann Ah, so suddenly thought of the system log to see, really found a lot of MySQL errors, and finally found the problem.

Open MySQL service on Win7 Server Windows cannot start the MySQL service (located on the local computer). Error 1067: Process terminated unexpectedly) "

Go to the Event Viewer application and you'll find a lot of MySQL error default storage engine (InnoDB) is not available

So into the MySQL installation directory to find My.ini There is a sentence: Default-storage-engine=innodb changed into MyISAM on it.

The MySQL service will be opened immediately.

workaround two

Re-install MySQL, always prompt "Unable to start the MySQL service, error 1067 process terminated unexpectedly
Reboot, repair registry is useless,"
online check, change What Basedir, also useless
I use mysql5.8,
look for to go, think of the integration environment such as Wampserver,pc_webserver installed before,
This software will My.ini, php.ini write to C: Windows directory, and set to read-only

Workaround:

workaround three

1, execute winmysqladmin, generate My.ini file
2, mysqld-install start MySQL service
3, net Start MySQL start MySQL service is normal
when the mysql-u root-p connection to the server did not start the error, look at the server service, indeed the MySQL service did not start, manual start generated 1067 errors, reinstall a few times MySQL, Mistakes remain. See that there are no errors in each configuration.

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

Mysqld.exe

Mysqld-nt.exe

Winmysqladmin.exe

When the box appears directly cancle out

And then click Winmysqladmin.ex E on the right hand that small icon to choose to start the service on the