[client]
port = 3306 
socket = /home/mysql/socket/mysql.sock 
[mysqld]
port = 3306
skip-grant-tables = 1
character_set_server = utf8

字符集改变
mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)

mysql>

本文转自 小小三郎1 51CTO博客，原文链接：http://blog.51cto.com/wsxxsl/2049004，如需转载请自行联系原作者