【技术帖】Mysql The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it work

【技术帖】Mysql The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it work

 

 

今天2B了,运行sql文件的时候,mysql返回信息-----Mysql The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it work。于是百度了一下,发现了解决办法。很简单。

 

 

1.找到你的mysql安装目录

2.找到文件  X:\AppServ\MySQL\my.ini,并打开这个my.ini文件

3.在ini的这个文件里找到skip-innodb这一行,然后在最前面加上一个#号。

 

#*** INNODB Specific options ***

# Use this option if you have a MySQL server with InnoDB support enabled

# but you do not plan to use it. This will save memory and disk space

# and speed up some things.

#skip-innodb     :就是这一行,最前面加上一个#号即可

 

 

4.重启mysql服务,这个你会吧?

 

计算机(我的电脑)--右键--管理--服务--mysql--右键--重新启动

 

ok 结贴。