怎么修改数据库默认编码方式？
看老师说修改了数据库编码方式 是utf8.。。 可能我走神了 没看见老师怎么修改的。。。
so 该怎么修改 and 怎么修改已创建的数据库的编码方式？
NadiaSmile
2016-09-24
4 回答
在安装的目录里有个文件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（修改）
举报
0/150
提交
取消
