Mysqld: unknownvariabledefault-character-setutf8 solutions have a need for friends can refer.
Mysqld: unknown variable default-character-set = utf8. If you need a solution, refer to it.
When using mysql5.5, follow the previous 5.1 Method to modify the my. cnf file, but the following error event type is prompted: Error
Event Source: MySQL
Event Type: None
Event ID: 100
Date: 2012-11-14
Event: 12:00:12
User: N/
COMPUTER: SVCTAG-HZWGF3X
Description:
Xxxbinmysqld: unknown variable 'default-character-set = utf8'
For more information, see Help and Support Center at http://www.mysql.com.
View Event Viewer-application to view mysql logs. Click here to view the logs:
Xxxbinmysqld: unknown variable 'default-character-set = utf8'
For more information, see Help and Support Center at http://www.mysql.com.
It seems that the default-character-set = utf8 setting is causing a disaster ....
Later I learned that MYSQL 5.5 modified the character set parameters.
It should be changed:
Use character_set_server = utf8 to replace default-character-set = utf8
This problem can be solved.
Try again, replace character_set_server = utf8