MySQL 8.0

I’m currently in the process of upgrading all my local mysql stuff to version 8. It looks like openhab doesn’t have support for this yet in either the mysql or jdbc-mysql modules. I’m wondering if I’m able to drop a new jar in the addons folder. The version in jdbc-mysql is mysql-connector-java-5.1.39.jar and is it possible to upgrade to 8.0.13? Any help is appreciated.

Hi!
Did you found a solution?

Facing the same problem here :slight_smile:

I created an issue: https://github.com/openhab/openhab1-addons/issues/5698

I found a solution.
In karaf console delete the v5 dB driver bundle with bundle:remove.
Download mysql v8 driver from maven repo and copy it to add-ons folder
Restart openhab an you’re done.

1 Like

And I created a PR, essentially doing the same

Amazing! One project updated. Thanks for the tip.

Hi!

With the new 2.4 stable the JDBC mysql persistence still loads the v5 driver not v8.
So i’m fine with my workaround…

sorry I’m a bit late to this party…
I’m getting a compatibility issue with MySQL v8 how do I implement this new connector?