Ubuntu MySQL encoding settings after 5.5

MySQL was installed.

Version: 5.5.28 OS: Ubuntu 12.10

' character% ' ; +--------------------------+----------------------------+| Variable_name            | Value                      |+--------------------------+----------------------------+| character_set_client     | UTF8                       | | character_set_connection | UTF8                       | | character_set_database   | latin1                     | | character_set_filesystem | binary                     | | character_set_ Results |    UTF8 |                       | character_set_server     | latin1                     | | character_set_system     | UTF8                       | | Character_sets_dir       

Create a table to view the format that is latin1, modify/etc/my.cnf add: [Client]default-character-set=utf8[mysqld]Default-character-set=utf8/etc/init.d/mysql restart #启动不了了. later the original version changed from 5, need to change this

[client]default-character-set=utf8[mysqld]character-set-server=utf8/etc/init.d/mysql restart  #启动成功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/|+--------------------------+----------------------------+

The modification was successful.

Ubuntu MySQL encoding settings after 5.5