1、首先关闭mysql服务器
进入任务管理器
进入my.ini配置文件,我的安装路径是C:/Program Files/MySQL/MySQL Server 5.5/
[client]
default
-
character
-
set
=utf8
port=3306
[mysql]
#网上下面这个 gbk 很多回答也是设置为utf8,结果就是乱码
default
-
character
-
set
=gbk
# 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
修改完保存,然后进入任务管理器启动mysql服务器【如果显示没有权限,可以复制出来文件,修改好后再替换就行】
符:ubuntu修改中文编码
转自:https://www.cnblogs.com/hzh19870110/p/6058862.html