MySQL5.5 Character Set Problems

Mysql 5.5 is installed, and the character set is faulty. The previous mysql servers can be configured in the my. cnf configuration file, but none of them can be used today.

Mysql 5.5 is installed, and the character set is faulty. The previous mysql servers can be configured in the my. cnf configuration file, but none of them can be used today.

Mysql 5.5 is installed, and the character set is faulty. The previous mysql servers can be configured in the my. cnf configuration file. However, an error is reported even though this is not the case:

At that time, no error logs were configured in the system, so you can configure the location of the error logs first to see where the error occurred:

Only when the error log is viewed is the character set error:

I don't even know it. I found someone on the Internet and found that mysql in mysql 5.5 no longer uses the default-character-set method.

For details, see:

Change default-character-set = utf8 to character-set-server = utf8. OK.