设置mysql字符集[Linux]

查看当前字符集

mysql> show variables like 'character_set_%';+--------------------------+----------------------------+| Variable_name            | Value                      |+--------------------------+----------------------------+| character_set_client     | utf8                       || character_set_connection | utf8                       || character_set_database   | latin1                     || character_set_filesystem | binary                     || character_set_results    | utf8                       || character_set_server     | latin1                     || character_set_system     | utf8                       || character_sets_dir       | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+8 rows in set (0.00 sec)

修改其中两项字符集

mysql> set character_set_database=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_server=utf8;Query OK, 0 rows affected (0.00 sec)

然后查看结果

mysql> show variables like 'character_set_%';+--------------------------+----------------------------+| 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)

成功！

呵呵哒 现在是2015年12月12日

本作者再一次编辑此贴  为什么？因为前面的方法根本无效

来吧 废话不多说 上干货！

第一步：

cd /etc

第二步：

vi my.cnf (如果你打开了这个文件，并且里头有东西，说明mysql自动生成了此文件，那么方法和网上大多数一样 但如果你和本作者一样打开了个空文件，请看下去)

第三部：

按"i"，继续输入如下字符

[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

init_connect='SET NAMES utf8'

然后按[ESC],再依次按":wq"，[ENTER]

最后一步：

service mysql restart

检验结果吧！

show variables like 'character_set_%';