MySQL: Modify the default encoding

Take utf8 as an example. Assume that you have followed the instructions in my previous blog to install MySQL and the installation is successful.

1. Stop MySQL

Sudo/etc/init. d/MySQL. server stop

2. modify my. CNF

Sudo gedit/etc/My. CNF

Find the corresponding part and add the red part.

[Client]
# MARK add
Default-character-set = utf8

# Omitted

# The MySQL Server
[Mysqld]
# MARK add
Character_set_server = utf8
# MARK add
Init_connect = 'set names utf8'

# Omitted

3. Start MySQL

Sudo/etc/init. d/MySQL. Server start

4. Connect to MySQL

Mysql-u root-P

5. Check the encoding.

There are many methods, such as three examples (the following three images ).

A. Command Method

B. Assume that after the default encoding is changed, you have created the database mydb and table mytable

Note: mytable can be created in mydb only after mydb is used.

C. \ s or status;