MySQL 8.0

(Andrew Oke) #1

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.

(Dominik Benner) #2

Did you found a solution?

(Martin van Wingerden) #3

Facing the same problem here :slight_smile:

I created an issue:

(Dominik Benner) #4

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.

(Martin van Wingerden) #5

And I created a PR, essentially doing the same

(Andrew Oke) #6

Amazing! One project updated. Thanks for the tip.

(Dominik Benner) #7


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