MySQL garbled problem solved

Modifying a configuration file

Simply leave the My.ini file and modify its encoding configuration.

Configured as follows

# Example MySQL config file for large systems.## the "for a" large system with memory = 512M where the system runs MAINL y# mysql.## You can copy this file to#/etc/my.cnf to set global options,# mysql-data-dir/my.cnf to set server-specific op  tions (in this# installation this directory is/usr/local/var) or# ~/.my.cnf to set user-specific options.## in the This file, You can use any long options that a program supports.# If you want to know which options a program supports, run the prog ram# with the "--help" option.# the following options would be passed to all MySQL clients[client] #password = Your_passwo Rddefault-character-set=utf8port = 3306socket =/tmp/mysql.sock# Here follows entries for some specific progra ms# the MySQL server[mysqld]default-character-set=utf8port = 3306socket =/tmp/mysql.sockskip-lockingkey_buffe r = 256mmax_allowed_packet = 1mtable_cache = 256sort_buffer_size = 1mread_buffer_size = 1mread_rnd_buffer_size = 4Mmyisam_ Sort_buffer_size = 64MthRead_cache_size = 8query_cache_size= 16m# Try number of CPU ' s*2 for thread_concurrencythread_concurrency = 8# Don ' t listen On a TCP/IP port at all. This can is a security enhancement,# if all processes then need to connect to mysqld run in the same host.# all Interactio N with Mysqld must is made via Unix sockets or named pipes.# Note that using the this option without enabling named Pipes on W indows# (via the "enable-named-pipe" option) would render mysqld useless!# #skip-networking# Replication Master Server (def  Ault) # Binary logging is required-replicationlog-bin=mysql-bin# required unique ID between 1 and 2^32-1# defaults to 1 if Master-host isn't set# but would not function as a master if Omittedserver-id = # Replication Slave (Comment out Master section to use this) # # to configure this host as a replication slave, you can choose between# both methods: # 1) Us E The Change Master to command (fully described in We manual)-# The syntax is:## change master to MASTER_HOST=&LT;host&gt, master_port=<port>,# Master_user=<user>, master_password=<password>; # where you repl Ace 

Post-modification effects

MySQL garbled problem solved