In Linux, MySQL 5.5/5.6 modifies the character set encoding to UTF8, mysqlutf8

In Linux, MySQL 5.5/5.6 modifies the character set encoding to UTF8, mysqlutf8

1. log on to MySQL and use show variables like 'character % '. The following character set is displayed:

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

The default Character Set of character_set_database and character_set_server is latin1.

2. The simplest and perfect modification method is to modify the character set key value in mysql's my. cnf file (pay attention to the configuration field details ):

1. Add default-character-set = utf8 to the [client] field, as shown below:

[client]port = 3306socket = /var/lib/mysql/mysql.sockdefault-character-set=utf8

2. Add character-set-server = utf8 to the [mysqld] field as follows:

[mysqld]port = 3306socket = /var/lib/mysql/mysql.sockcharacter-set-server=utf8

3. Add default-character-set = utf8 to the [mysql] field, as shown below:

[mysql]no-auto-rehashdefault-character-set=utf8

After the modification, the service mysql restart restarts the mysql service to take effect. Note: The [mysqld] field is different from the [mysql] field. No one has reported this on the Internet.

Use show variables like 'character % '; Check that the database encoding 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/ |+--------------------------+----------------------------+

In Linux, the method for modifying the character set encoding of MySQL 5.5/5.6 To UTF8 is all the content that I have shared with you. I hope you can give me a reference and support me a lot.