可以手动创建或cp /usr/share/mysql/my-medium.cnf /etc/my.cnf
如果手动创建的话，内容如下：
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#user=mysql
character_set_server=utf8
collation-server=utf8_general_ci
#default-character-set=utf8
init_connect='SET NAMES utf8'
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
default-character-set=utf8
##########################################################
编码问题
mysql 5.5不识别 default-character-set=utf8
，可以用character_set_server=utf8替换
本文转自 穿越防火墙 51CTO博客，原文链接:http://blog.51cto.com/sjitwant/1692157