[DerMega]

Hi folks,

I´ve got an interesting problem. I installed openmediavault and there I installed mySQL in a docker container.
Connecting to mySQL via another docker container and phpMyAdmin works fine.
Also Connecting from Win10 via MySQL Qorkbench works fine.
I imported my SQL-DB from my old mySQL Server.
After a whole day of fiddling around I managed my Win10 Kodi with 18.6 to connect to the DB and play the movies again.

I ported the advancedsettings.xml (see below) from my win machine to the kodi installation on my RPI1 (OSMC with 18.6). But the logfile says he can´t connect.
The Pi is in the same network and he can ping the NAS-system without problems.

Code:

ERROR: Unable to open database: xbmc_video116 [2026](SSL connection error: unknown error number)
ERROR: Unable to create new database

Whole Log: dixololufo.kodi (paste)

xml:
<?xml version="1.0" encoding="utf-8"?>

<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>192.168.100.74</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

        <name>xbmc_video</name>

    </videodatabase>

    <musicdatabase>

        <type>mysql</type>

        <host>192.168.100.74</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

        <name>mymusic</name>

    </musicdatabase>

    <pathsubstitution>

      <substitute>

         <from>special://masterprofile/Thumbnails/</from>

         <to>smb://192.168.100.74/xbmcthumbs</to>

      </substitute>

    </pathsubstitution>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

    <importresumepoint>true</importresumepoint>

  </videolibrary>

</advancedsettings>

I googled for hours but can´t get any solution up to now. 
Can you help me? 

best regards

[mobrien118]

Same problem here...

I'm running Kodi in OSMC (on Raspberry Pi).

I had it working with whatever version of MySQL comes with Ubuntu 19.10, but when I upgraded to 20.04 today, which uses MySQL 8.0.19 it stopped working.

I read some stuff that said to enable "default-authentication-plugin=mysql_native_password" in my mysqld.conf file, but that isn't working on its own.

I can connect successfully from Kodi on my Android, though.

Hopefully these will give you some clues and you can fix this for me ;-) j/k - if I figure anything out, I'll post back.

--mobrien118