Error trying to connect mariadb from another host

I have one hassos with installed mariadb addon, and try to connect from another hassos with recorder.

I get error:
Error during connection setup: (MySQLdb._exceptions.OperationalError) (1045, "Access denied for user 'admin'@'ip_of_my_connecting_host' (using password: YES)")

From: https://www.home-assistant.io/addons/mariadb/#host

host 
   (string)(Required)
    Host for account. If you need an account on multiple hosts, use ‘%’. 

Hope it’s of help.

Also, MariaDB does not allow any connections other than from “localhost” as standard. I know you need to change some config (can’t remember where or how) to allow external connections.

Simon

I configured with “%” but still not working.

Probably MariaDB addon has this in configuration file:

bind-address 127.0.0.0

instead

bind-address 0.0.0.0

But I don’t know how to add this in configuration of MariaDB addon?

Did you ever solve the problem? I am facing the same problem now. I remember for a long time ago, i used host: '%' but that’s deprecated…

Yes. I installed phpMyAdmin addon and created user and database from phpMyAdmin.

2 Likes

Thank you! After 2 hours of research I solve this issue manually creating the correct user as seen in the error log.
How to:

CREATE USER ‘homeassistant’@‘172.30.32.1’ identified by ‘mypersonalpassword’

By default the addon created ‘homeassistant’@‘%’ so I manually created a new one with the correct IP address.

what if when i install phpmyadmin i get an error of starting phpmyadmin Access denied for user 'service'@'172.30.33.2

1 Like