MariaDB addon as Kodi database

Hi everyone.
A bit of history…
I’ve been using home assistant core (on python venv) on rpi4 for a few months now. Recently I found problems configuring some stuff which eventually I decided to use the docker version. That gave me nothing more, so eventually I went for home assistant OS (took me a few days to properly understand what is the difference!) to see what the mouth watering addon store is.
I also found out this hassio OS is so limiting in terms of you don’t fee you actually own the OS!

Anyway, I used to have a MariaDB on my raspberry pi4 (raspbian os) that was a simple shared database for my KODI devices around the house.

Now that I don’t have my OS, and am using hassio os, I saw that there’s an addon called MariaDB with another one phpMyAdmin to manage the databases.
I don't want to use MariaDB for hassio recorder - at least for now. I want to use it for KODI. This is my current MariaDB config:

databases:
  - homeassistant
  - kodi
logins:
  - username: homeassistant
    password: mypassword123
  - username: kodi
    password: kodi
    host: '%'
    skip-netwroking: 0
    skip-bind-address: 0
rights:
  - username: homeassistant
    database: homeassistant
  - username: kodi
    database: kodi
    host: '%'
    grant: ALL PRIVILEGES ON

(I added those host: '%' from scraping the internet)
I had no success connecting to kodi database either with Kodi itself or a simple python script using mariadb package.

I constantly get this error

Error connecting to MariaDB Platform: Can't connect to MySQL server on '192.168.1.211' (10061)

Which apparently means the MariaDB server is not listening to the port.
I spent a day doing whatever I found on the internet, but had no success. Please help.
[my hassio version: 2021.2.3; hardware rpi4]

I have this setting to access the db from other clients.
Auswahl_450

1 Like

How did I miss that. You’re my champion mate - it was easier than I thought. Thanks.