I was able to get the user and db created but this was on the Proxmox server and not in the HA VM. Not sure if this is correct or not. I added this to my configurations.yaml file:
recorder:
db_url: mysql://homeassistant:password@core-mariadb/homeassistant?charset=utf8
My MariaDB database and user are both called homeassistant.
I get these errors in the logs when I restart HA:
=======================================
2021-01-10 13:06:23 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:26 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:29 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:32 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:33 WARNING (MainThread) [homeassistant.setup] Setup of recorder is taking over 10 seconds.
2021-01-10 13:06:35 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:38 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:41 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:44 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:47 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:50 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, “Access denied for user ‘homeassistant’@‘172.30.32.1’ (using password: YES)”)
(Background on this error at: http://sqlalche.me/e/13/e3q8) (retrying in 3 seconds)
2021-01-10 13:06:50 ERROR (MainThread) [homeassistant.setup] Setup failed for recorder: Integration failed to initialize.
2021-01-10 13:06:50 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of history. Setup failed for dependencies: recorder
2021-01-10 13:06:50 ERROR (MainThread) [homeassistant.setup] Setup failed for history: Could not set up all dependencies.
2021-01-10 13:06:50 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of logbook. Setup failed for dependencies: recorder
2021-01-10 13:06:50 ERROR (MainThread) [homeassistant.setup] Setup failed for logbook: Could not set up all dependencies.
2021-01-10 13:06:55 ERROR (MainThread) [homeassistant.config_entries] Error unloading entry configuration.yaml for sensor
Traceback (most recent call last):
File “/usr/src/homeassistant/homeassistant/config_entries.py”, line 321, in async_unload
result = await component.async_unload_entry(hass, self) # type: ignore
File “/usr/src/homeassistant/homeassistant/components/sensor/init.py”, line 72, in async_unload_entry
return await hass.data[DOMAIN].async_unload_entry(entry)
File “/usr/src/homeassistant/homeassistant/helpers/entity_component.py”, line 172, in async_unload_entry
raise ValueError(“Config entry was never loaded!”)
ValueError: Config entry was never loaded!
2021-01-10 13:06:56 ERROR (MainThread) [homeassistant.setup] Unable to set up dependencies of default_config. Setup failed for dependencies: history, logbook
2021-01-10 13:06:56 ERROR (MainThread) [homeassistant.setup] Setup failed for default_config: Could not set up all dependencies.
2021-01-10 13:07:06 WARNING (MainThread) [homeassistant.components.netatmo] Webhook not registered - https and port 443 is required to register the webhook
=================================
Any ideas what I did wrong in setup?