Are you sure that all Kodi versions are the same on all clients? Otherwise it won't work:
Enabled the 'Wait for network' option on your RPi?
I am using Kodi Krypton v17 Beta 1 on my mac. Wait for network option is enabled.There a tons of these messages in 01_KODI.log
Code13:56:10 61.760685 T:1962635264 ERROR: Unable to open database: MyMusic60 [2003](Can't connect to MySQL server on '192.168.0.196' (113))
so your videodatabase works but not your music? can you paste full log
and does it work with a normal mysql client?
No it was just an example. All the databases are not working. Log is attached.
well you can't connect, try to comment bind-address in my.cnf. or pastebin the whole my.cnf
mysql error 113 "no route to host"
I have the same problem you have.
The problem seems to ly in the fact its not loading the hostname from the config.
as for my my config format is
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>10.0.1.1</host>
<port>3306</port>
<user>root</user>
<pass>removed</pass>
<name>Kodi_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>10.0.1.1</host>
<port>3306</port>
<user>root</user>
<pass>removed</pass>
<name>Kodi_music</name>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>
where the error my RPI gives is
11:37:40 18.293171 T:1961963520 ERROR: Unable to open database: Kodi_music60 [1045](Access denied for user 'root'@'10.0.1.5' (using password: YES))
same goes for video
What version of MySQL Server are you using? And is it actually MySQL rather than MariaDB etc.?
I have an Intel NUC and I am having the same problem (latest Libreelec, installed yesterday). When I boot Kodi I have no movie-database while the log is saying:
ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.2.33' (101))The database is running fine and I am not using name resolution as I entered the IP address into the advancedsettings.xml. I have enabled the "Wait for network"-option but I think it still does not wait long enough.
When I kill Kodi with "killall -9 kodi.bin" then it will restart with same settings but now the mysql database works fine. So for me it looks like a timing problem on boot, no?
[hr]
Well, it seems I have it working now: The default 10 seconds delay was just not enough it seems (naughty NUC being too fast). I have increased it to 30 seconds and now MySQL seems to be working reliably. Too bad to lose >10 seconds when booting because of this 
