Linux Mint under the Mysql Chinese support problem _mysql

A. MySQL does not support Chinese by default, and its server and DB defaults to latin1 encoding. So we're going to change it to Utf-8 code, because utf-8 contains the binary encoding of most languages on the planet.

1. Turn off MySQL service

Sudo/etc/init.d/mysql stop

2. Modify MySQL configuration file

The MySQL profile defaults to the/ETC/MY.CNF or/etc/mysql/my.cnf directory and goes to the command line

sudo gedit/etc/mysql/my.cnf

Add default-character-set = UTF8 under [client]
Add character-set-server = UTF8 under [mysqld]

3. Restart MySQL OK

Sudo/etc/init.d/mysql start

PS: Some commands for operating MySQL in INIT.D startup management:

/etc/init.d/mysql Start|stop|restart|reload|force-reload|status

Important point: Be sure to follow the above method step-by-step implementation, the most important thing is to shut down the service before modifying the file, remember!!!

The above content is small to introduce the Linux Mint under the MySQL Chinese support problem, I hope you like.