phpmyadmin 没有 innodb引擎

解决方法：

第一：把你的my.ini文件复制到 c:/window 下面   （申明: 一般你安装mysql的地方里面的my.ini设置跟 window下面是一样的)

第二：设置my.ini 文件
           [mysqld]

          # generic configuration options
           port    = 3306
           socket    = /tmp/mysql.sock
           #default-character-set=gbk
           basedir=D:/server/mysql
           datadir=D:/server/mysql/data

          # *** INNODB Specific options ***
           #skip-innodb                                                             (必须)
           innodb_additional_mem_pool_size = 2M                  (必须)

          innodb_buffer_pool_size = 16M                                (必须)

          innodb_data_file_path = ibdata1:10M:autoextend     (必须)

          innodb_data_home_dir = "D:/server/mysql/"               (必须)

           innodb_file_io_threads = 4

           #innodb_force_recovery=1

          innodb_thread_concurrency = 16

          innodb_flush_log_at_trx_commit = 1                             (必须)

         #innodb_fast_shutdown

         innodb_log_buffer_size = 8M                                         (必须)

          innodb_log_file_size = 5M                                              (必须)

         innodb_log_files_in_group = 3

         innodb_log_group_home_dir = "D:/server/mysql/"          (必须)

         innodb_max_dirty_pages_pct = 90

        #innodb_flush_method=O_DSYNC

         innodb_lock_wait_timeout = 50                                         (必须)

         innodb_log_arch_dir = "D:/server/mysql/"                        (必须)

         

第三：从新启动你的phpmyadmin OK

第四：要是启动不了phpmyadmin 那就移除，从新安装一下 在从新启动 phpmyadmijn

另外收录到的：

我想用外键功能，是否必须用innoDB引擎？
但我用phpMyAdmin查看时，innoDB是灰色的，点击进去以后，上面写着：
InnoDB has been disabled for this MySQL server.
请问我的MYSQL里是否没有这个引擎？我是否需要去下载安装？怎么安装？

我已经在MYSQL安装目录下的skip-innodb的左边加了个#，但还是没法用innoDB.使用alter table replyarticle type=innoDB;
就提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

答案

不是安装，你的MY.INI或者MY.CNF文件里面，有个skip innoDB的语句，删除了就有了