MySQL displays "error 1067: Unexpected Process Termination", and mysql1067

MySQL displays "error 1067: Unexpected Process Termination", and mysql1067

1. Error description

2. Error cause

Today, I am exploring how to use commands to view MySQL logs. I have checked a lot of information, mostly by modifying the configuration of my. ini file. After I modified the configuration, I was about to restart the MySQL server. I first executed net stop mysql and found that the service was still not stopped. So I went directly to the Windows 7 service to stop the MySQL service, after the service is stopped and restarted again, the above warning window will pop up.

3. Solution

To solve this problem, I have read a lot of information and summarized the following points:

(1) Delete the my. ini file

(2) modify the default storage engine

(3) Delete ib_logfile0, ib_logfile1, ibdata1 under data

(4) reinstall MySQL

I tried the first three methods many times, but it was ineffective. The warning window still pops up. Finally, I had to reinstall MySQL and found that the warning window was no longer displayed. As a result, it is proved that the solution should be based on the actual situation and should not be described as follows.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.