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！