Solution to garbled characters After mysql is reinstalled

After mysql is reinstalled, garbled code appears. Solution: view the 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>

 

You can only set the database and server character sets to utf8 in the configuration file, otherwise it does not work in the command line: Stop command:

net stop mysql

 

Start command:

net start mysql

 

Mysql core configuration file my. ini [mysql] mainly configures the command line client parameter default-character-set = utf8 ---- affects the client, connection, result [mysqld], and configures the server parameter character-set-server = utf8 ----- to affect the database. when adding function functions to server mysql, Set

Set global log_bin_trust_function_creators = 1; specify the parameter; otherwise, the creation will fail.