ERROR 1286 (42000): Unknown table engine ‘InnoDB’

来自http://tunps.com/error-1286-42000-unknown-table-engine-innodb

I was getting the error “ERROR 1286 (42000): Unknown table engine ‘InnoDB’” when trying to create/alter tables with the InnoDB engine. You can check for this warning by issuing the create or alter statements and then running
show warnings;
in the same mysql client session.

Check if you have InnoDB support enabled:

mysql> show variables like 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | DISABLED   |
+---------------+-------+
1 row in set (0.04 sec)

The problem is that InnoDB is not enabled by default in Debian distributions of my.cnf. To enable it, simply comment the following lines under the [mysqld] section.

#skip-innodb

via

DISABLED和NO是有区别的，DISABLED表示具有该功能，只是没有启用（通过启动参数or配置文件)，NO表示彻底的不支持的编译版本。