https:\/\/youtu.be\/Q25AEpWMmXE<\/a><\/p>\n\u5b89\u88c5MySQL:<\/p>\n
sudo apt-get -y install mariadb-server python3-pymysql python-pymysql\r\nsudo systemctl enable mysql\r\nsudo systemctl restart mysql<\/code> \u521b\u5efamysql\u7528\u6237\u540d\u5bc6\u7801\uff1a CREATE DATABASE hass;\r\nCREATE USER 'hass'@'%' IDENTIFIED BY 'hass123456';\r\nGRANT ALL ON *.* TO 'hass'@'%';\r\nFLUSH PRIVILEGES;<\/code><\/pre>\nHome Assistant\u914d\u7f6e\u6587\u4ef6\u589e\u52a0\uff1a<\/p>\n
purge_keep_days\uff1a\u4ee3\u8868\u4fdd\u7559\u51e0\u5929\u7684\u65e5\u5fd7\r\n\r\nrecorder:\r\n purge_keep_days: 5\r\n db_url: mysql+pymysql:\/\/hass:hass123456@localhost\/hass?charset=utf8<\/code><\/pre>\n\u53c2\u8003\u4e0b\u9762\u4f8b\u5b50\u53ef\u4ee5\u6392\u9664\u8bb0\u5f55\u548c\u4ec5\u8bb0\u5f55\u67d0\u4e9b\u5185\u5bb9\uff1a<\/p>\n
recorder:\r\n purge_days: 5\r\n db_url: mysql:\/\/dbuser:password@localhost\/dbname?charset=utf8\r\n exclude:\r\n domains:\r\n - automation\r\n - weblink\r\n - updater\r\n entities:\r\n - sun.sun # Don't record sun data\r\n - sensor.last_boot\r\n - sensor.date\r\n include:\r\n domains:\r\n - sensor\r\n - switch\r\n - media_player\r\n exclude:\r\n entities:\r\n - sensor.last_boot\r\n - sensor.date<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Home Assistant\u7684SQLite\u6570\u636e\u5e93\u5728\u9ed8\u8ba4\u7684\u914d\u7f6e\u6587\u4ef6\u5939\u7684home-assistant_v… \u7ee7\u7eed\u9605\u8bfb Home Assistant 0.103.6 \u66f4\u6539MySQL\u6570\u636e\u5e93<\/span><\/i><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[35,12],"tags":[],"class_list":{"0":"post-1938","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-home-assistant","7":"category-mysql","8":"h-entry","10":"h-as-article"},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/1938","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1938"}],"version-history":[{"count":20,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/1938\/revisions"}],"predecessor-version":[{"id":2340,"href":"https:\/\/sumju.net\/index.php?rest_route=\/wp\/v2\/posts\/1938\/revisions\/2340"}],"wp:attachment":[{"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sumju.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/i0.wp.com\/sumju.net\/wp-content\/uploads\/2020\/02\/mysql.jpg?resize=1024%2C576&ssl=1\")
<\/a>