mysql rpm安装遇到的问题

没有/etc/my.conf 

可以手动创建或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