[0.97.2] MariaDB issue - this seems to be common?

Suddenly after a reboot, the recorder won’t start anymore. Can anyone help me out here?

More topics are reporting this same error:

Error during connection setup: (MySQLdb._exceptions.OperationalError) (1130, "Host 'core-samba.local.hass.io' is not allowed to connect to this MariaDB server")
(Background on this error at: http://sqlalche.me/e/e3q8) (retrying in 3 seconds)

I tried changing the MariaDB config: “host”: “%”
Also tried this change in configuration.yaml:
db_url: mysql://hass:drk-jo4e1z-3d4pdr98f@core-mariadb/homeassistant
to:
db_url: mysql://hass:[email protected]/homeassistant

And also uninstalled and reinstalled the MariaDB Hass.io add-on. But no luck.

Hass.io / HA 0.97.2 / supervisor 184 / host Ubuntu Server 18.04.2

This one got me a little while back as well.

Ran Mariadb for around 2 weeks then one day it didnt start.

I didnt really need it, so it was easier to just remove it and go back to the default. I never dug too deep into it.

Now I’m considering switching to a new db again, so I’m curious if anyone else had the issue and how to fix.

Have the same issue. Rebooted, and get this error…

Just solved it. I’ve changed the host into % and rebooted again

{
  "databases": [
    "homeassistant"
  ],
  "logins": [
    {
      "username": "hass",
      "host": "%",
      "password": "************"
    }
  ],
  "rights": [
    {
      "username": "hass",
      "host": "%",
      "database": "homeassistant",
      "grant": "ALL PRIVILEGES ON"
    }
  ]
}

Ah two places to put the %. That fixes it

In the 2.0 as I see there is no option host, so as I see there is no way to reach the db from outside.
I can’t find any relevant in documents. Guys, you who had this porblem and solved with host param, what’s your opinion?

This is my config now:

databases:
  - homeassistant
logins:
  - username: hass
    host: '%.local.hass.io'
    password: xxxxxxxxx
rights:
  - username: hass
    host: '%.local.hass.io'
    database: homeassistant
    grant: ALL PRIVILEGES ON

that,s nice but in my log:
20-03-03 18:39:58 WARNING (MainThread) [supervisor.addons.validate] Unknown options host
20-03-03 18:39:58 WARNING (MainThread) [supervisor.addons.validate] Unknown options host

How does your config look like?

Mine:

recorder:
  db_url: mysql://hass:xxxxxxxxx@core-mariadb/homeassistant?charset=utf8
recorder:
  db_url: mysql://hass:zzzzzzzzz@core-mariadb/homeassistant?charset=utf8
  purge_keep_days: 20
  purge_interval: 1