MySQL数据库执行sql语句创建数据库和表提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have

时间:2022-09-21 09:09:26

MySQL创建数据库 只想sql文件创建表时候提示

The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

原因:

有可能是mysql配置文件my.ini文件中skip-innodb 开启了 ,找到mysql目录找到my.ini文件搜索定位到skip-innodb 

MySQL数据库执行sql语句创建数据库和表提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have

解决办法

前面加上#  ---->#skip-innodb

MySQL数据库执行sql语句创建数据库和表提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have

 重新启动mysql

开始输入cmd--->右键管理员省份运行

MySQL数据库执行sql语句创建数据库和表提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have