博客

[mysqld]
port=3306
character-set-server=utf8
basedir=/data/mysql
datadir=/data/mysqldata
#innodb_buffer_pool_size=8M
lower-case-table-names=1
wait_timeout=31536000
interactive_timeout=31536000
sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION



[mysqld_safe]

log-error=/data/mysqllog/error.log

pid-file=/data/mysqllog/mysql.pid

tmpdir = /tmp

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

sql_mode设置问题，改为上面两个参数即可正常运行sql