Mysql修改默认编码linux

先show variables like ‘character%’;     //其实这里不用like也行,你试试,得出来所有的变量
然后看到应该是这样的:
mysql> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

查看到以后，停止MySQL服务（bin/mysqladmin -u root shutdown在/etc/下找到my.cnf，如果没有就把MySQL的安装目录下的support-files目录下的my-medium.cnf复制到/etc/下并改名为my.cnf即可。打开my.cnf以后，在[client]和[mysqld]下面均加上default-character-set=utf8，保存并关闭。

最后重新启动。