云服务器安装的MYSQL5.6数据库默认为MyISAM引擎,有些程序需要InnoDB引擎,
MyISAM引擎更改InnoDB引擎 方法如下:
修改配置文件my.ini  该配置文件在D盘MYSQL安装目录下
打开MY.INI
搜索default-storage-engine
default-storage-engine=MyISAM 修改为
default-storage-engine=InnoDB
然后下面一行是:
default-tmp-storage-engine=InnoDB
-------------------------修改成功后是下面这样的---------------------------------------
default-storage-engine=InnoDB
default-tmp-storage-engine=InnoDB
-----------------------------------------------------------------
不仅如此,还需要删除以下,把下面凡是loose-开头的全部删除,否则MYSQL无法启动,删除后保存my.ini,就可以启动MYSQL服务了
loose-skip-innodb
loose-innodb-trx=0 
loose-innodb-locks=0 
loose-innodb-lock-waits=0 
loose-innodb-cmp=0 
loose-innodb-cmp-per-index=0
loose-innodb-cmp-per-index-reset=0
loose-innodb-cmp-reset=0 
loose-innodb-cmpmem=0 
loose-innodb-cmpmem-reset=0 
loose-innodb-buffer-page=0 
loose-innodb-buffer-page-lru=0 
loose-innodb-buffer-pool-stats=0 
loose-innodb-metrics=0 
loose-innodb-ft-default-stopword=0 
loose-innodb-ft-inserted=0 
loose-innodb-ft-deleted=0 
loose-innodb-ft-being-deleted=0 
loose-innodb-ft-config=0 
loose-innodb-ft-index-cache=0 
loose-innodb-ft-index-table=0 
loose-innodb-sys-tables=0 
loose-innodb-sys-tablestats=0 
loose-innodb-sys-indexes=0 
loose-innodb-sys-columns=0 
loose-innodb-sys-fields=0 
loose-innodb-sys-foreign=0 
loose-innodb-sys-foreign-cols=0