怎么修改mysql的默认编码格式_怎么修改数据库默认编码方式？

在安装的目录里有个文件my.ini文件，一般计算机都隐藏了后缀.ini，所以就是找到my文件，打开在

[client]

port=3306

[mysql]

default-character-set=utf8(修改)

# SERVER SECTION

# ----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure that

# you have installed the server correctly (see above) so it reads this

# file.

#

[mysqld]

# The TCP/IP Port the MySQL Server will listen on

port=3306

#Path to installation directory. All paths are usually resolved relative to this.

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

#Path to the database root

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"

# The default character set that will be used when a new schema or table is

# created and no character set is defined

character-set-server=utf8(修改)