[OtheA]

That Database should be fine.
The master Database "Kodi_U01_Video_116" should have 42 tables/views.
and each other database should have 37 tables/views.    

I wiped everything and changed my user to reflect yours so I'd have to edit as little as possible in case I was missing something.  This is a clean install of both the database and Kodi.  Confirmed that master database has 42 tables/views, but the others have none.  It creates the other database, but it's empty.  Am I missing some initial steps to set this up?  KODI_18 user has all privileges.  Sorry for my ignorance.

Empty meaning there's no tables for Kodi_U02_Video_116.

Okay... disregard.  I did it again, and it worked...  Weird...  Must have been user error.  

hhmm that sounds strange, but its all working now? 

It may have been how phpMyAdmin was handing it?  What ended up working is when I first ran it, it created the empty database and failed with the error I provided earlier.  I then had to refresh phpMyAdmin, select the database and see that it was empty, then when I ran it the second time, everything was imported without a hitch.  I'll be the first to admit I'm not a DBA, so I'm not sure if I was doing something wrong.  Maybe my NAS was timing out or something?  I don't know, but now all databases are there with the correct amount of tables you referenced.

I'm working on another Kodi box and will verify it can see the database.  I'm presuming in the advancedsettings.xml on the other system I reference Kodi_U02_Video_ in order for it to access it's associated database.  Thanks so much for the guide.  I'm one step closer.