关于MySQL5.5不能执行带有中文字符的语句解决方法

my.ini文件在C:\ProgramData\MySQL\MySQL Server 5.5\my.ini

注意ProgramData文件可能已经隐藏了，设置一下： 组织--文件夹和搜索选项--查看--显示隐藏文件、文件夹或驱动器（打勾即可）

具体方法是修改my.ini这个文件的一下内容即可；

[client]
no-beep

# pipe
# socket=mysql
port=3306

[mysql]

default-character-set=gbk   这里原来是utf8将其改为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.
#
# server_type=3
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# The Pipe the MySQL Server will use
# socket=mysql

# 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="E:\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修改的是上边那行，而不是这行

转载于:https://www.cnblogs.com/tyyj89/archive/2012/09/26/2704708.html