Unable to start the MySQL service "1067 process unexpected termination" workaround

Original: Http://www.111cn.net/database/mysql/48888.htm This article summarizes a variety of solutions that cause the MySQL prompt to fail to start the MySQL service "1067 process unexpected termination", You can try to refer to a classmate who has encountered a MySQL failure to start.

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: The process terminated unexpectedly) "Enter" 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 II

"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.

Unable to start the MySQL service "1067 process unexpected termination" workaround