查看与设置MySQL数据库字符集.docxVIP

Liunx下修改MySQL字符集： 1.查找MySQL的cnf文件的位置 find / -iname *.cnf -print /usr/share/mysql/my-innodb-heavy-4G.cnf/usr/share/mysql/my-large.cnf/usr/share/mysql/my-small.cnf/usr/share/mysql/my-medium.cnf/usr/share/mysql/my-huge.cnf/usr/share/texmf/web2c/texmf.cnf/usr/share/texmf/web2c/mktex.cnf/usr/share/texmf/web2c/fmtutil.cnf/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf/usr/share/texmf/tex/jadetex/jadefmtutil.cnf/usr/share/doc/MySQL-server-community-5.1.22/my-innodb-heavy-4G.cnf/usr/share/doc/MySQL-server-community-5.1.22/my-large.cnf/usr/share/doc/MySQL-server-community-5.1.22/my-small.cnf/usr/share/doc/MySQL-server-community-5.1.22/my-medium.cnf/usr/share/doc/MySQL-server-community-5.1.22/my-huge.cnf 2. 拷贝 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnf其中的一个到/etc下，命名为my.cnfcp /usr/share/mysql/my-medium.cnf /etc/my.cnf 3. 修改my.cnf vi /etc/my.cnf 在[client]下添加default-character-set=utf8 在[mysqld]下添加default-character-set=utf8 4.重新启动MySQL[root@bogon ~]# /etc/rc.d/init.d/mysql restartShutting down MySQL??????????????????????????????????????? [ 确定 ]Starting MySQL.??????????????????????????????????????????? [ 确定 ][root@bogon ~]# mysql -u root -pEnter password:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.1.22-rc-community-log MySQL Community Edition (GPL) Type help; or \h for help. Type \c to clear the buffer. 5.查看字符集设置 mysql show variables like collation_%;+----------------------+-----------------+| Variable_name??????? | Value?????????? |+----------------------+-----------------+| collation_connection | utf8_general_ci || collation_database?? | utf8_general_ci || collation_server???? | utf8_general_ci |+----------------------+-----------------+3 rows in set (0.02 sec) mysql show variables like character_set_%;+--------------------------+----------------------------+| Variable_name??????????? | Value????????????????????? |+--------------------------+----------------------------+