linux下配置mysql默认编码utf8

linux下配置mysql默认编码utf8

下面是需要在对应地方加入的配置

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8 
collation-server=utf8_general_ci 

重启mysql之后，妥妥的了

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1

Connection id:      45
SSL:            Not in use
Current pager:      stdout
Using outfile:      ''
Using delimiter:    ;
Server version:     5.1.41-3ubuntu12 (Ubuntu)
Protocol version:   10
Connection:     Localhost via UNIX socket
Client characterset:    utf8
Server characterset:    utf8
UNIX socket:        /var/run/mysqld/mysqld.sock
Uptime:         1 hour 2 min 23 sec

Threads: 1  Questions: 321  Slow queries: 0  Opens: 263  Flush tables: 1  Open tables: 23  Queries per second avg: 0.85