Linux MySQL change character set encoding and Ubuntu under change MySQL default encoding

Linux MySQL Tutorial change character set encoding and Ubuntu under change MySQL default encoding

Find configuration file
/etc/mysql/my.cnf
Under [client], add
Default-character-set=utf8
Add under [mysqld]
Default-character-set=utf8
Reboot the server
Service MySQL Restart
Type a command in MySQL:
Show variables like ' character_set_% '
The results appear as follows:
Character_set_client UTF8
Character_set_connection UTF8
Character_set_database latin1
Character_set_filesystem binary
Character_set_results UTF8

Ubuntu under change MySQL default encoding (character set)

installing MySQL
sudo apt-get install mysql-server #直接自动获得可用版本
You can also write this
sudo apt-get install mysql-server-5.0 #安装mysql服务器5.0 version
After installation
/etc/init.d/mysql Start (stop) starts and stops the server
/etc/mysql/main configuration file location my.cnf
/var/lib/mysql/placed is the Database Tutorial table folder, where MySQL is equivalent to Windows MySQL under the Date folder
After you start MySQL, log in to MySQL with Root
isher@isher-ubuntu:~$ Mysql-u Root
>show variables like ' character% '; #执行编码显示
+--------------------------+----------------------------+
| variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | Latin1 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | Latin1 |
| Character_set_system | UTF8 |
| Character_sets_dir | /usr/share/mysql/charsets/|
+--------------------------+----------------------------+
At some point, we continue to modify the MySQL default database encoding to ensure that some of the migrated programs can be displayed correctly, edit the my.cnf file for coding changes, Windows can be directly with the MySQL Server Instance Config Wizard to set
Modify 3 my.cnf 1/etc/mysql/my.cnf files under Linux
Locate the client configuration [clients] add below
Default-character-set=utf8 default character set is UTF8
After finding [mysqld] Add
Default-character-set=utf8 default character set is UTF8
init_connect= ' Set NAMES UTF8 ' (set to connect to MySQL database with UTF8 encoding to make MySQL database run UTF8)
After the modification, restart the MySQL can, query show variables like ' character% ';
+--------------------------+----------------------------+
| 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/|
+--------------------------+----------------------------+
This method is also valid for standard MySQL versions, and for/etc/my.cnf files, you need to my-large.cnf from Mysql/support-files's folder CP to/ETC/MY.CNF