Mysql startup error 1067 Simple Solution

Solution: the mysql database will automatically generate temporary files in the temp folder under the windows folder on drive C at runtime. These files are not large, but the number of files is very large, there may be hundreds of thousands of files in a month, and the root cause of mysql startup failure is these files. So all we need to do is delete these files, but we recommend that you do not

Solution: the mysql database will automatically generate temporary files in the temp folder under the windows folder on drive C at runtime. These files are not large, but the number of files is very large, there may be hundreds of thousands of files in a month, and the root cause of mysql startup failure is these files. So all we need to do is delete these files, but we recommend that you do not

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 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 !!