MySQL 1067 Error

 

I installed MySQL5.5 on my computer a few days ago (under Windows 2k3 server) and it has been used well. However, I set it to manual start and it cannot be started today, A bunch of solutions on the Internet have no effect, and the solution on the internet is roughly the same (basically back-and-forth copy ), you cannot solve it yourself.

 

I repeatedly thought about the operations over the past two days and suddenly thought that I installed a QSoft RamDisk tool yesterday. Isn't it a strange tool? No! By the way, I moved the system environment variable and specified it to a folder of the drive letter generated by RamDisk. Let's try it again,

 

 

 

Run the net start mysql command again.

 

 

Oh, the startup is successful!

 

So I made the following inference:

1. MySQL will use windows system environment variables, that is, MySQL will generate temporary files under C: \ windows \ Temp at startup.

2. If the system environment variable changes after MySQL is installed, MySQL cannot be started. The error code is 1067.

3. If the System Variables change before MySQL is installed, MySQL may start properly (no tests have been performed)

4. If MySQL can be started normally in 3rd cases, you can change the configuration file to specify the path generated by the temporary file during MySQL startup. (Specifying temporary files to RamDisk will greatly improve the performance. I have specified both the temporary files in the browser and VS2010)

 

 

2. Adjusting the server's character set will cause a 1067 error.

Error 1067 may occur in the following cases:

1. Set the character set of the server and change the character set of the my. ini Server

2.set the Server's Character Set and use mysqlworkbench.exe to change the Server's Character Set in Server Administration

 

How can this problem be solved?

Use % MySQLInstallPath % bin/MySQLInstanceConfig.exe to change the character set and restart it. If you are using this program later, try to use the above program to change the character set.

From doz's blog