在sql-mode =“NO_ENGINE_SUBSTITUTION”之后,mysql服务重新启动失败

当我在sql-mode = "NO_ENGINE_SUBSTITUTION"添加sql-mode = "NO_ENGINE_SUBSTITUTION"后,尝试重新启动mysql服务时出现此错误

错误:

作业mysql.service失败,因为控制进程退出错误代码。 有关详细信息,请参阅“systemctl status mysql.service”和“journalctl -xe”。

一点背景:

我试图在运行Ubuntu 14.04的DO VPS中安装ISPConfig 3,并得到以下错误:

错误的SQL模式。 您应该使用NO_ENGINE_SUBSTITUTION。 将sql-mode =“NO_ENGINE_SUBSTITUTION”添加到此服务器的mysql-config中的mysqld部分,然后重新启动mysqld

为了解决这个问题,我在sql-mode="NO_ENGINE_SUBSTITUTION"添加了sql-mode="NO_ENGINE_SUBSTITUTION"

现在我很困惑,为了让我的ISPconfig安装继续下去。

注意:mysql服务在上面的sql模式下工作正常。

tail -30 /var/log/mysql/error.log返回以下内容:

2017-07-20T14:11:06.111509Z 0 [Note]closures插件'INNODB_FT_DELETED'2017-07-20T14:11:06.111517 [Note]closures插件'INNODB_FT_BEING_DEL ETED'2017-07-20T14:11:06.111513Z 0 Z 0 [注意]closures插件'INNODB_FT_DEFAULT_S TOPWORD'2017-07-20T14:11:06.111521Z 0 [Note]closures插件'INNODB_METRICS'2017-07-20T14:11:06.111525Z 0注意closures插件' INNODB_TEMP_TABLE_I NFO'2017-07-20T14:11:06.111529Z 0 [Note]closures插件'INNODB_BUFFER_POOL_ STATS'2017-07-20T14:11:06.111533Z 0 [注意]closures插件'INNODB_BUFFER_PAGE_ LRU'2017-07-20T14 :11:06.111537Z 0 [注意]closures插件'INNODB_BUFFER_PAGE'2017-07-20T14:11:06.111541Z 0 [注意]closures插件'INNODB_CMP_PER_INDE X_RESET'2017-07-20T14:11:06.111545Z 0 [注意]closures插件'INNODB_CMP_PER_INDE X'2017-07-20T14:11:06.111549Z 0 [Note]closures插件“INNODB_CMPMEM_RESET”2017-07-20T14:11:06.111553Z 0注意事项closures插件'INNODB_CMPMEM'2017-07 -20T14:11 :06.111557Z 0 [注意]closures插件'INNODB_CMP_RESET'2017-07-20T14:11:06.111561Z 0 [注]closures插件'INNODB_CMP'2017-07-20T14:11:06.111566Z 0 [注意]closures插件'INNODB_LOCK_WAITS'2017-07-20T14:11:06.111570Z 0 [Note]closures插件'INNODB_LOCKS'2017-07-20T14:11:06.111575Z 0注意:closures插件'INNODB_TRX'2017-07-20T14:11 :06.111579Z 0【注意】closures插件'InnoDB'2017-07-20T14:11:06.113947Z 0【注意】InnoDB:FTS优化线程退出。 InnoDB:将缓冲池转储到/ var / li b / InnoDB:缓冲池转储在170720 14:11:06完成2017-07-20T14:11:07.352417Z 0 [注意] InnoDB:关机完成; 日志序号2801206 2017-07-20T14:11:07.355057Z 0 [注意] InnoDB:删除临时表空间数据文件:“ibtmp1”2017-07-20T14:11:07.355086Z 0 [注]closures插件'MEMORY'2017 -07-20T14:11:07.355095Z 0【注意】closures插件“mysql_native_passwo rd”2017-07-20T14:11:07.355370Z 0 [注]closures插件'binlog'2017-07-20T14:11:07.355861Z 0 [注意] / usr / sbin / mysqld:closures完成