[idahomike]

I have tried many times unsuccessfully to get Kodi to work with MySQL 8, and this last weekend I gave it another go. I finally have things working but my question is, does Kodi support the caching sha2 password feature of MySQL 8? and if so how do you make it work.  After many hours of frustration and trying to figure out why I could get other programs to connect to the database using the same credentials Kodi would not.  When I finally tried creating a new user with standard password authentication everything works fine. I would like to use the caching sha2 passwords if that's an option though.

Thanks for any insight

[Klojum]

Afaik, Kodi does not support any encrypted MySQL connections at this time. The same goes for all the local SQLite databases.
MySQL 8.0 defaults to the new sha2 caching method, but no functionality has been added for this into Kodi.

So, applying the mysql_native_password into MySQL's authentication settings is the way to go for the time being.

[idahomike]

This is what I needed to know.  Thank you for your reply.

[Klojum]

Thread marked solved.