RPi4 - MySQL issue cannot connect to database

  • 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

    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