Ubuntu安装mysql 不支持中文的问题

先查看mysql版本号，5.5和之前的5.2的中文编码配置不一样。

 

mysql:5.5

      修改文件 /etc/mysql/my.cnf

     
[mysqld]下添加的应该为：

character-set-server=utf8

collation-server=utf8_general_ci

保存退出

$sudo service mysql restart

果然成功重启

$mysql

之后出现

mysql>status;

 status
--------------
mysql  Ver 14.14 Distrib 5.5.32, for debian-linux-gnu (x86_64) using readline 6.2

Connection id:          36
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.5.32-0ubuntu0.12.04.1 (Ubuntu)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 14 sec

Threads: 1  Questions: 107  Slow queries: 0  Opens: 179  Flush tables: 1  Open tables: 43  Queries per second avg: 7.642
--------------

成功！

 

mysql:5.2

     1.在终端输入命令 sudo gedit /etc/mysql/my.cnf在打开的文件中
找到［client]在下面加入
default-character-set=utf8
找到 [mysqld_safe]在下面加入
default-character-set=utf8
找到[mysqld]在下面加入
default-character-set=utf8
init_connect='SET NAMES utf8'
找到［mysql］在下面加入
default-character-set=utf8

重启：$sudo service mysql restart

mysql>show variables like '%char%';

如果出现的列表各项内容和以下相同表明配置成功了，

---------------------－ -----－－--------------
| 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/