Mysql after the reload appears garbled set to UTF8 can be resolved _mysql

View current connection system parameters: Show VARIABLES like '%char% ';

Mysql> Show variables like ' char% ';
+--------------------------+----------------
| variable_name | Value
+--------------------------+----------------
| character_set_client | Gbk
| character_set_connection | Gbk
| Character_set_database | Latin1
| Character_set_filesystem | Binary
| Character_set_results | Gbk
| Character_set_server | Latin1
| Character_set_system | Utf8
| Character_sets_dir | c:/

+--------------------------+----------------
8 rows in Set (0.00 sec)
Mysql>

The database and server character sets can only be set to UTF8 in the configuration file, otherwise it will not work

On the command line: Stop command: net stop MySQL

Start command: net start MySQL
MySQL Core configuration file My.ini

[MySQL] main configuration command line client parameters Default-character-set=utf8----affect client, connection, result
[mysqld] Configure server parameters CHARACTER-SET-SERVER=UTF8-----affect database server

When MySQL adds function functions, set the set global Log_bin_trust_function_creators=1 first; Specify parameters otherwise the creation is unsuccessful