mariadb乱码解决

mysql>show variables like "%char%";

+--------------------------+---------------+ 
| Variable_name            | Value       |
+--------------------------+---------------+ 
| character_set_client     | gbk        |
| character_set_connection | gbk     |
| character_set_database   | utf8 |
| character_set_filesystem | binary |
| character_set_results    | gbk        |
| character_set_server     | utf8       |
| character_set_system     | utf8      |
+--------------------------+-------------+ 

修改/etc/mysql/my.cnf
On MySQL 5.5 I have in my.cnf

[mysqld] 
init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake 

[client] default-character-set=utf8 [mysql] default-character-set=utf8

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