Learning MySQL encoding settings in Linux (solving Chinese garbled characters)

OS environment-fedora12

 

Configuration File Location-/etc/My. CNF

 

Stop MySQL Service

# Service mysqld stop

 

Modify content

 

Add in the [client] configuration section: (if this configuration section is not available by default, add one)

### Default Character Set: utf8

Default-character-set = utf8

 

Add in [mysqld]

### Default Character Set: utf8

Default-character-set = utf8

### (Set utf8 encoding when connecting to the MySQL database to run the MySQL database as utf8)

Init_connect = 'set names utf8'

 

Start MySQL Service

# Service mysqld start

 

Description: Under the/usr/share/MySQL folder

My-large.cnf

My-huge.cng

My-medium.cnf

My-small.cnf

The four files correspond to the setting templates of Different server configurations (mainly memory size and server usage). Change the name to my. after CNF, you can replace/etc/My. CNF file.