Mysql compressed version Chinese garbled Solution

Mysql compressed version Chinese garbled solution compressed version mysql does not like the installation version can be configured directly, need to be manually configured. Although there are various methods on the Internet: the default configuration in my compressed version is not in the msyql directory. ini, I see a mysql-default.ini file in it, rename it to mysql. after ini, you can simply change its configuration to the following,

1 [mysqld] 01 basedir = D:/Data/mysql02 datadir = D: /Data/mysql/data03 port = 330604 server_id = 11050607 # Remove leading # to set options mainly useful for reporting servers.08 # The server ults are faster for transactions and fast SELECTs.09 # Adjust sizes as needed, experiment to find the optimal values.10join _ buffer_size = 128M11sort_buffer_size = 2M12read_rnd_buffer_size = 2M1314sql_mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

 

Start with mysqld and code 1 [mysql] 2 according to the online Configuration

Default-character-set = utf8

 

And use the mysql Command

1 set names 'utf8'

 

After checking the configurations, garbled characters are still displayed. The solution is to add the following code under [mysqld ]:

1character-set-server = utf8

 

Sure enough, solve the garbled problem,