Windows cannot start the MySQL service, error 1067

problem: MySQL service startup exception

Find out why

Check the error message for the Client-02.err file in the D:\mysql-5.6.20-winx64\data directory (the file with the Err suffix is the MySQL log file)

Modify the configuration to resolve the inability to start the MySQL service

Change the Default-charater-set=utf8 in the My.ini file to Character_set_server=utf8, and the MySQL service can start normally.

fall into the dead problem

when I re-logged in to MySQL, there was an error "Unknown variable Character-set-server=utf8" that I had recently encountered. This is not

Did you get into the death question? Write "Default-charater-set=utf8" cannot start MySQL service, write "Character_set_server=utf8" cannot log in

Mysql. What makes me so good ...

Summary

　　Finally, I have deleted the "Character_set_server=utf8" and "Default-charater-set=utf8". The service starts normally and logs on to MySQL normally.

I know this is not a good solution, because it involves coding problems, can not be deleted just. So you have to understand the configuration properties of MySQL and how to solve

garbled problem.

Windows cannot start the MySQL service, error 1067