云服务器安装的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