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]