Modify MySQL encoding to UTF8

The simplest solution to the MySQL Chinese encoding problem is: Modify the mysql configuration file/etc/mysql/my. cnf (in CentOS, It is/etc/my. cnf), add the following command under [client:

Default-character-set = utf8

[Mysqld] Add the following command:

Default-character-set = utf8init_connect = 'set NAMES utf8'

NOTE: If there is no [client] segment, manually add it to the [client] segment. Then restart MySQL. Verify if it takes effect:

Mysql> show variables like 'Char %'
+ -------------------------- + ---------------------------- +
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/
+ -------------------------- + ---------------------------- +
8 rows in set (0.00 sec)

Mysql>

In this way, the new database is UTF-8 encoded by default.