我下的是解压版5.6.39,64位的
看网上教程要把my.default.ini改成my.ini安装
那么问题来了
我用my-default.ini的时候,安装启动都可以,但是编码却是这个样子,改my-default.ini都没用
我用set改编码,重启后还会变回去
用my.ini的时候,net start mysql就会报1067的错误,求大神指导,百度啥的都翻遍了,没有管用的

my-default.ini和my.ini配置:
[client]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[mysql]
default-character-set = utf8
[mysqld]
basedir = D:\software\servers\mysql-5.6.39-winx64
datadir = D:\software\servers\mysql-5.6.39-winx64\data
# port = .....
# server_id = .....
default-character-set = utf8
character_set_server = utf8
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
看网上教程要把my.default.ini改成my.ini安装
那么问题来了
我用my-default.ini的时候,安装启动都可以,但是编码却是这个样子,改my-default.ini都没用
我用set改编码,重启后还会变回去
用my.ini的时候,net start mysql就会报1067的错误,求大神指导,百度啥的都翻遍了,没有管用的

my-default.ini和my.ini配置:
[client]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[mysql]
default-character-set = utf8
[mysqld]
basedir = D:\software\servers\mysql-5.6.39-winx64
datadir = D:\software\servers\mysql-5.6.39-winx64\data
# port = .....
# server_id = .....
default-character-set = utf8
character_set_server = utf8
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
