mysql5.5字符编码设置_Mysql 5.5/5.6修改字符集为UTF-8

记得以前的mysql在client、mysqld、mysql三段加入default-character-set=utf8即可，但是在新的vps上安装了mysql 5.5以后发现这么修改导致无法启动，在这里记录一下新版本mysql的修改方法，用于备忘：[client]

default-character-set=utf8

[mysql]

default-character-set=utf8

[mysqld]

collation-server = utf8_unicode_ci

init-connect=’SET NAMES utf8′

character-set-server = utf8

修改完成后重启mysql，然后使用：SHOW VARIABLES LIKE 'character%';

查看字符集是否成功修改为：mysql> SHOW VARIABLES LIKE 'character%';

+--------------------------+----------------------------+

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

+--------------------------+----------------------------+