MYsql 编码UTF 8

[qq_33295093]

这是my-default.ini


# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.


[mysqld]
#show variables like 'char%';
#设置basedir指向mysql的安装路径
basedir=E:\MYSQL\mysql-5.6.23-winx64
datadir=E:\MYSQL\mysql-5.6.23-winx64\data
port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8
character-set-filesystem =utf8


[mysql]
default-character-set=utf8

[client]

port = 3306
socket = /tmp/mysql.sock
default-character-set=utf8


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

my.default.ini 不管怎么改成gbk utf8 cmd - show variables like 'char%';
都是下图。





真是醉了这个mysql...

[qq_33295093]

http://www.cnblogs.com/1-Admin/p/6032768.html 解决了。支持一下。

[阳泉酒家小当家]

解决就好

[qq_33295093]

引用 2 楼 yupeigu 的回复:

解决就好

哈哈。60给你了。