Ubuntu modified MySQL code for UTF8

Ubuntu uses apt-get after installing MySQL, the server's default encoding is Latin1, the following changes the server's code to UTF8.

View MySQL and encoded information

Look at the MySQL message:

Mysql> select version (); +-------------------------+| Version () |+-------------------------+| 5.5.41-0ubuntu0.14.04.1 |+-------------------------+

Coding related information:

mysql> show variables like  ' 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       | /usr/share/mysql/charsets/ |+--- -----------------------+----------------------------+

You can see that both the Character_set_database and character_set_server codes are latin1.

Modify the MySQL encoding

Open the MySQL configuration file /etc/mysql/my.cnf

Vim/etc/mysql/my.cnf

append to [MySQL]

Default-character-set=utf8

After saving, restart MySQL.

/etc/init.d/mysql restart

The code is correct.

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

Complete.

Ubuntu modified MySQL code for UTF8