《Mysql應(yīng)用解析mysql 5.5字符集問(wèn)題》要點(diǎn)：
本文介紹了Mysql應(yīng)用解析mysql 5.5字符集問(wèn)題，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
MYSQL應(yīng)用安裝了個(gè)5.5版本的mysql,字符集呈現(xiàn)了問(wèn)題,之前的mysql服務(wù)器都是通過(guò)在my.cnf配置文件中進(jìn)行配置便可,可是今兒怎么著都不行一直報(bào)錯(cuò)：
MYSQL應(yīng)用當(dāng)時(shí)系統(tǒng)中也沒(méi)有配置差錯(cuò)日志,所以只能是先配置下差錯(cuò)日志的位置,看看到底是哪里出錯(cuò)了：
代碼如下:
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
結(jié)果查看了差錯(cuò)日志才發(fā)現(xiàn)是字符集的差錯(cuò)：
代碼如下:
[ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
居然不認(rèn)識(shí),上網(wǎng)上了找了下發(fā)現(xiàn)也有人遇到了,說(shuō)是5.5中mysql不再使用default-character-set這種寫(xiě)法了.
MYSQL應(yīng)用具體請(qǐng)看：http://dev.mysql.com/doc/refman/5.5/en/server-options.html#option_mysqld_default-character-set
MYSQL利用把default-character-set=utf8 改成： character-set-server=utf8就可以了.
代碼如下:
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)
OK出工了.
歡迎參與《Mysql應(yīng)用解析mysql 5.5字符集問(wèn)題》討論，分享您的想法，維易PHP學(xué)院為您提供專業(yè)教程。
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/13608.html
