Question

MySQL中，如何修改collation_server的latin1_swedish_ci为utf8_general_ci？

如题，在MySQL中，使用SHOW VARIABLES LIKE '%colla%'的查询结果为：collation_connection utf8_general_ci collation_database utf8_general_ci collation_server latin1_swedish_ci 如何修改collation_server的latin1_swedish_ci为utf8_general_ci？

Answer 1

通过MySQL命令行修改:
mysql> set collation_server=utf8;
Query OK, 0 rows affected (0.01 sec)

再查看 mysql> show variables like 'character_set_%';

Answer 2

还可以修改mysql.ini