I try to set up Mysql with Hass 0.45. First I did this:
mysql -uroot -p
CREATE DATABASE hass;
USE hass;
CREATE USER ‘hassuser’@‘localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON hass.* TO ‘hassuser’@‘localhost’;
flush privileges;
Then in configuration.yaml:
recorder:
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?