Unable to set up MySQL VideoDB (Kodi18)

After updating to Kodi 18 RC5 (necessary to get Netflix working) I am facing several issues that I want to address separately.

This issue concerns setting up MySQL in the My OSMC > Network settings.
After choosing the submenu entry MySQL I can choose to enable MySQL VideoDB or MusicDB. The ‘content screen’ next to the menu is and stays empty besides these two options.

Choosing Enable MySQL VideoDB and exiting triggers a screen with MySQL settings are incomplete. Discard MySQL settings changes? which either brings me back to the menu or lets me exit with discarded settings.

My logfile only gives me

20:40:37.225 T:3761935088   DEBUG: PushCecKeypress - received key  b duration 0
20:40:37.232 T:4071764576   DEBUG: HandleKey: 11 (0x0b, obc244) pressed, action is Select
20:40:37.277 T:3796890352   DEBUG: ctl 910511 : sql item name :
20:40:37.281 T:3796890352   DEBUG: ctl 910512 : sql item host :
20:40:37.281 T:3796890352   DEBUG: ctl 910513 : sql item port :
20:40:37.281 T:3796890352   DEBUG: ctl 910514 : sql item user :
20:40:37.281 T:3796890352   DEBUG: ctl 810515 : sql item pass :
20:40:37.295 T:3796890352   DEBUG: Missing MySQL Video setting: host
20:40:37.302 T:4071764576   DEBUG: ------ Window Init (DialogConfirm.xml) ------
20:40:37.415 T:3761935088   DEBUG: PushCecKeypress - received key  b duration 189

What could be the reason?

I know the remote section of MyOSMC doesn’t work with Kodi 18 yet, so I wonder if the MySQL section has a similar issue. If you’re familiar with working on the command line, you can log into your OSMC box and manually add some stuff to the Kodi advancedsettings.xml file. Specifically:



You obviously need to change to host as well as put in the correct user name and password, but that should get you running.

BTW, the advancedsettings.xml file is in .kodi/userdata/