Mysql Stopped after installing


When I install mysql 5.7 it isn’t working. It says it is completed but when I check hearthbeat it says it stopped.

Hello Tom,

Sorry for the inconvenience caused.

We’ll look into the issue and get back to you.

The error being reported was InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata1 are 0x4000.

The error generally appears when database service of lower version points to some data created with the higher version of InnoDB engine.

We were able to resolve the issue by removing MySQL data directory (/var/lib/mysql).

NOTE :: Please note that in case of an existing database, you will lose all the data when the MySQL data directory is removed.

1 Like