Mysql gives errors, "Table storage engine for 'events' doesn't have this option"

I try to set up Mysql with Hass 0.45. First I did this:

mysql -uroot -p
USE hass;
CREATE USER ‘hassuser’@‘localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON hass.* TO ‘hassuser’@‘localhost’;
flush privileges;

Then in configuration.yaml:
purge_days: 5
db_url: mysql://hassuser:password@localhost/hass

Then Hass is restarted. The recorder, logbook and history components fails, the log says:

2017-05-25 06:10:56 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (_mysql_exceptions.OperationalError) (1031, “Table storage engine for ‘events’ doesn’t have this option”) [SQL: ‘CREATE INDEX ix_events_time_fired ON events (time_fired)’] (retrying in 3 seconds)
2017-05-25 06:10:56 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Component failed to initialize.

How to solve this?

Maybe you need to set the default DB engine to innodb?