mysql 不支持innodb,MySQL不支持InnoDB的解决方法

MySQL不支持InnoDB的解决方法

在mysql中输入SHOW variables like “have_%”查看，显示如下：

mysql> SHOW variables like “have_%”

-> ;

+———————–+———-+

| Variable_name | Value |

+———————–+———-+

| have_archive | YES |

| have_bdb | NO |

| have_blackhole_engine | NO |

| have_compress | YES |

| have_crypt | NO |

| have_csv | NO |

| have_dynamic_loading | YES |

| have_example_engine | NO |

| have_federated_engine | NO |

| have_geometry | YES |

| have_innodb | DISABLED |

| have_isam | NO |

| have_merge_engine | YES |

| have_ndbcluster | NO |

| have_openssl | DISABLED |

| have_query_cache | YES |

| have_raid | NO |

| have_rtree_keys | YES |

| have_symlink | YES |

+———————–+———-+

19 rows in set (0.00 sec)

蓝色表示我的MYSQL并不支持innodb。

打开我的my.ini文件，找到skip-innodb，改成#skip-innodb, 之后重启mysql.

mysql> SHOW variables like “have_%”

-> ;

+———————–+———-+

| Variable_name | Value |

+———————–+———-+

| have_archive | YES |

| have_bdb | NO |

| have_blackhole_engine | NO |

| have_compress | YES |

| have_crypt | NO |

| have_csv | NO |

| have_dynamic_loading | YES |

| have_example_engine | NO |

| have_federated_engine | NO |

| have_geometry | YES |

| have_innodb | YES |

| have_isam | NO |

| have_merge_engine | YES |

| have_ndbcluster | NO |

| have_openssl | DISABLED |

| have_query_cache | YES |

| have_raid | NO |

| have_rtree_keys | YES |

| have_symlink | YES |

+———————–+———-+

19 rows in set (0.00 sec)

OK！