Solve The InnoDB feature is disabled; you need MySQL built with InnoDB, innodbfeature

Solve The InnoDB feature is disabled; you need MySQL built with InnoDB, innodbfeature

It is easy to roll back the current affairs at home. Once it is difficult for the company to use it, I checked that the mysql table type is not innodb. Then I found that the table structure cannot be changed, the following error is reported. Modify the my. ini file in mysql. The procedure is as follows:

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

This option is disabled in the mysql configuration file!

Find the my. ini file in the mysql installation directory.

Locate skip-innodb, and add # To the front.

Restart the mysql service.