数据组件的配置、mysql数据库及其它

操作步骤

include/exclude配置样式样例

history: include: domains: - sensor - switch - media_player exclude: entities: - sensor.last_boot - sensor.date
recorder组件配置样例

recorder: purge_interval: 1 purge_keep_days: 10 # db_url: sqlite:////home/pi/.homeassistant/home-assistant_v2.db db_url: mysql://pi:hachina1234@127.0.0.1/my_homeassistant?charset=utf8 exclude: entities: - sun.sun
mysql安装与初始化
服务器端安装

sudo apt-get install mysql-server
客户端：

sudo apt-get install libmariadbclient-dev libssl-dev

sudo pip3 install mysqlclient
MYSQL中创建数据库、用户、授权SQL命令：

CREATE DATABASE my_homeassistant;

USE mysql;

CREATE user 'pi' IDENTIFIED BY 'hachina1234';

UPDATE user SET plugin='mysql_native_password' WHERE User='pi';

GRANT ALL PRIVILEGES ON my_homeassistant.* TO 'pi';

FLUSH PRIVILEGES;
历史数据相关组件