Set mysql encoding on linux

Set mysql encoding in linux

Set mysql encoding in linux

First, find the location of the MySql cnf file:

[Root @ flyHome gaoxiang] # find/-iname '*. cnf'-print

/Etc/pki/tls/openssl. cnf

/Etc/my. cnf

/Usr/share/openvpn/easy-rsa/2.0/openssl-0.9.6.cnf

/Usr/share/openvpn/easy-rsa/2.0/openssl. cnf

/Usr/share/openvpn/easy-rsa/1.0/openssl. cnf

/Usr/share/mysql/my-small.cnf.

/Usr/share/mysql/my-large.cnf.

/Usr/share/mysql/my-innodb-heavy-4G.cnf.

/Usr/share/mysql/my-huge.cnf.

/Usr/share/mysql/my-medium.cnf.

/Usr/share/doc/mysql-server-5.5.18/my-small.cnf

/Usr/share/doc/mysql-server-5.5.18/my-large.cnf

/Usr/share/doc/mysql-server-5.5.18/my-innodb-heavy-4G.cnf

/Usr/share/doc/mysql-server-5.5.18/my-huge.cnf

/Usr/share/doc/mysql-server-5.5.18/my-medium.cnf

Then copy one of the my-small.cnf, my-medium.cnf, my-huge.cnf, my-innodb-heavy-4G.cnf to/etc/my. cnf

[Root @ flyHome gaoxiang] # cp/usr/share/mysql/my-medium.cnf/etc/my. cnfcp: overwrite "/etc/my. cnf "? Y

Modify my. cnf

[Root @ flyHome gaoxiang] # vi/etc/my. cnf

Add under [client]

Default-charater-set = utf8

Add under [mysqld]

Collation_server = utf8_general_ci

Character_set_server = utf8

After saving and exiting, restart mysqld:

[Root @ flyHome gaoxiang] # service mysqld restart

After completing the above operations, you will be OK.

Let's take a look at the effect:

Mysql> show variables like 'character _ set _ % ';

+ -------------------------- + ---------------------------- +

| Variable_name | Value |

+ -------------------------- + ---------------------------- +

| Character_set_client | utf8 |

| Character_set_connection | utf8 |

| Character_set_database | utf8 |

| Character_set_filesystem | binary |

| Character_set_results | utf8 |

| Character_set_server | utf8 |

| Character_set_system | utf8 |

| Character_sets_dir |/usr/share/mysql/charsets/|

+ -------------------------- + ---------------------------- +