Need help, people! I want to record history to SQL on another Raspberry Pi on the same network. So I installed there SQL Server and add new db. Call it home_assistant
My SQL Server:
In configuration.yaml I add this lines
recorder:
db_url: mysql://my_login:[email protected]/home_assistant?charset=utf8
After restart I get this error:
Error during connection setup: (MySQLdb._exceptions.OperationalError) (2002, “Can’t connect to MySQL server on ‘192.168.1.80’ (115)”) (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation) (retrying in 3 seconds)
And:
Setup failed for recorder: Component failed to initialize.
Unable to set up dependencies of history. Setup failed for dependencies: recorder
Setup failed for history: Could not set up all dependencies.
Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
Setup failed for logbook: Could not set up all dependencies.
What am I doing wrong? Thanks for help