安裝了個5.5版本的mysql，字符集出現(xiàn)了問題，之前的mysql服務(wù)器都是通過在my.cnf配置文件中進行配置便可，可是今兒怎么著都不行一直報錯：

當(dāng)時系統(tǒng)中也沒有配置錯誤日志，所以只能是先配置下錯誤日志的位置，看看到底是哪里出錯了：

復(fù)制代碼 代碼如下:

user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
log-error=/var/log/mysql/error.log
lc-messages-dir = /usr/share/mysql
skip-external-locking
default-character-set=utf8

復(fù)制代碼 代碼如下:

[ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'

具體請看：

把default-character-set=utf8 改成： character-set-server=utf8就可以了。

復(fù)制代碼 代碼如下:

root@chenDBA:/etc/mysql# vim my.cnf
root@chenDBA:/etc/mysql# service mysql start
mysql start/running, process 5904
root@chenDBA:/etc/mysql# mysql -uroot -p
Enter password:
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| 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.00 sec)