MariaDB and Access Denied

Tags: #<Tag:0x00007fc41f10a5f0> #<Tag:0x00007fc41f109ec0>

Home Assistant Core 0.112.3 on a RPi 4+

I installed the mariadb add-on and, as far as I can tell, it’s working fine with my HomeAssistant installation. If I navigate to LogBook in the HA web interface, I see the data that I’m collecting. So, that seems fine.However, I do keep getting errors in my log for mariadb.

My configuration is as follows:

databases:
  - homeassistant
logins:
  - username: ha_maria
    password: <redacted>
rights:
  - username: ha_maria
    database: homeassistant

I’m guessing the errors are from a different component which relies on the database. The IP address that the error is coming from is unknown to me. Perhaps that’s a different docker process?

Here’s the error:

2020-07-08 19:26:11 18 [Warning] Access denied for user 'homeassistant'@'172.30.32.1' (using password: YES)
2020-07-08 19:26:11 19 [Warning] Access denied for user 'homeassistant'@'172.30.32.1' (using password: YES)
2020-07-08 19:26:11 21 [Warning] Access denied for user 'homeassistant'@'172.30.32.1' (using password: YES)

Any help in resolving this would be appreciated!

1 Like

I’m having the same issue. Same IP address as well but user is ‘service’. Did you resolve this?

2020-07-08 19:26:11 21 [Warning] Access denied for user 'service'@'172.30.32.1' (using password: YES)

Hi, did you solve this?

Make sure you edited the connection example given to use in your config.yaml if you changed the default username and password

Default below

recorder:
  db_url: mysql://homeassistant:[email protected]/homeassistant?charset=utf8mb4

homeassistant should be changed to ha_maria:YourPW or whatever you have set in the MariaDB configuration

Hope that helps!