Want to move history db to another Pi


#1

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: http://sqlalche.me/e/e3q8) (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