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