Liunx下修改MySQL字符集:
1.查找MySQL的cnf文件的位置find / -i name '*.cnf' -print
2. 拷贝 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4G.cnf其中的一个到/etc下,命名为my.cnf
cp /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 restart
5.查看字符集设置
mysql> show variables like 'collation_%';
mysql> show variables like 'character_set_%';
修改指定数据库字符集:
1)修改数据库的字符集
mysql>use mydb
mysql>alter database mydb character set utf-8;
2)创建数据库指定数据库的字符集
mysql>create database mydb character set utf-8;
通过配置文件修改:
1、修改/var/lib/mysql/mydb/db.optdefault-character-set=latin1
default-collation=latin1_swedish_ci
为:
default-character-set=utf8
default-collation=utf8_general_ci
2、重起MySQL:
[root@bogon ~]# /etc/rc.d/init.d/mysql restart
通过MySQL命令行修改:
mysql> set character_set_client=utf8;
mysql> set character_set_connection=utf8;
mysql> set character_set_database=utf8;
mysql> set character_set_results=utf8;
mysql> set character_set_server=utf8;
mysql> set character_set_system=utf8;
mysql> set collation_connection=utf8;
mysql> set collation_database=utf8;
mysql> set collation_server=utf8;