Mysql startup error 1067 Simple Solution

 Solution

When mysql is running, temporary files are automatically generated in the temp folder under the windows folder on drive C. These files are not large, but the number of files is very large, there may be hundreds of thousands of files in a month. The root cause of mysql startup failure is these files. So what we need to do is to delete these files, however, it is recommended that you do not open this folder to delete it. If there are many files, it is easy to open slowly or even kill the server, therefore, using the del command in the cmd window is the best solution (as shown below)

After the above operations, you only need to wait a moment until all the junk files are deleted. At this time, you only need to restart your mysql service. In order not to forget to clear these junk files, and do not want to delete them every time, you can use windows scheduled tasks to work with the previous batch processing for regular execution. Sometimes, when the database cannot be started, check some small details first, and you will find the problem very easy !!