如何修改MYSQL的默认编码

MySQL的默认编码是Latin1，不支持中文.要让默认编码变为utf8。可进行如下配置：

 

SET GLOBAL character_set_client     = utf8;
SET GLOBAL character_set_connection = utf8;
SET GLOBAL character_set_database   = utf8;
SET GLOBAL character_set_results    = utf8;
SET GLOBAL character_set_server     = utf8;

SET GLOBAL character_set_system     = utf8;
重启Mysql：

检查结果：

show variables like "char%";