I built a raspbian buster on a RPi3 running MariaDB 10 and I cannot get either of my RPi4's to connect to the DB.
logs are here Full Debug Logs
Logs report
Code
2019-04-11 12:28:42.028 T:2875597680 ERROR: Unable to open database: MyMusic72 [2002](Can't connect to MySQL server on '192.168.1.23' (101))
advancedsettings.xml below
Code
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.23</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.23</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
Display More
using heidiSQL on my desktop, I can reach and browse the RPi3 db using the same username/password kodi/kodi as in the advancedsettings.xml
Desktop/ LE 9.2.1 / RPi3 MariaDB are all on the same VLAN. See image
Tried with 2 RPi4's running LE 9.2.1 and both report the same cannot connect message in the logs.
Any thoughts?
Thanks,
Greg