将这个默认48M的值改为 512M或 更大
# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=512M
innodb_strict_mode=0
innodb_strict_mode=0
这一句是关闭严格模式,有时创建大表的时候会需要。建议删除这句。
重启MYSQL
我的电脑->(右键)管理->服务与应用程序->服务->MYSQL->开启(停止、重启动)