The modified character set code of MySQL 5.6 under Linux is UTF8 (to solve the problem of Chinese scrambling)


1, Log in to MySQL to view SHOW VARIABLES LIKE 'character%'; the following character set is displayed as follows:

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

character_set_database and character_ set_ The default character set of the server is still latin1.

2, The simplest and perfect way to modify mysql my.cnf Character set key value in the file (pay attention to the configured field details):

First look at your my.cnf Where is the file? On Linux, enter the find / -iname '*.cnf' -print command to find it my.cnf File, and then modify it as shown below.

1,stay[client]Add to field default-character-set=utf8，As follows:
 
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
 
2,stay[mysqld]Add to field character-set-server=utf8，As follows:
 
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
character-set-server=utf8
 
3,stay[mysql]Add to field default-character-set=utf8，As follows:
 
[mysql]
no-auto-rehash
default-character-set=utf8

After the modification, service mysql restart will take effect after restarting mysql service. Note: there is a difference between the [mysqld] field and the [mysql] field. There is no feedback on this on the Internet.


Use SHOW VARIABLES LIKE 'character%'; check and find that the database code has been changed to utf8.

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