MySQL Character set settings

Configuration file path:/full/path/mysql/bin/my.cnf (default =/ETC/MY.CNF)

[Client]
Default-character-set=utf8

[MySQL]
Default-character-set=utf8

[Mysqld]
init_connect= ' SET collation_connection = Utf8_unicode_ci '
init_connect= ' SET NAMES UTF8 '
Character-set-server=utf8
Collation-server=utf8_unicode_ci
Skip-character-set-client-handshake

See how MySQL is encoded
Show variables like ' character% ';

Among them, Character_set_client is the client coding mode;
Character_set_connection the encoding used to establish the connection;
Coding of character_set_database database;
Character_set_results the encoding of the result set;
Character_set_server the encoding of the database server;

As long as the above four is guaranteed to use the same encoding method, there will be no garbled problem.

MySQL Character set settings