MySQL appears "error 1067: Process terminated unexpectedly"

1. Error description

2. Cause of Error

Today, I am groping how to use the command to view the MySQL log, check out a lot of information, mostly by modifying the My.ini file configuration. I modified the configuration, ready to restart the MySQL server, first executed the net stop MySQL, the discovery service or not stopped, so I went directly to the Windows7 service to stop the MySQL service, stop the service and restart again, pop up the above warning window

3. Solutions

In order to solve this problem, I consulted a lot of information, summed up several points:

(1) Delete my.ini file

(2) Modifying the default storage engine

(3) Delete the ib_logfile0,ib_logfile1,ibdata1 under Data

(4) Re-install MySQL

The first three ways, I tried many times, no effect, still pop up the warning window. Finally, there is no way, I re-installed MySQL, the results found no longer pop-up warning window. This proves that the solution should be based on the actual situation encountered, can not be scripted.

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

MySQL appears "error 1067: Process terminated unexpectedly"