Can you repost this as it’s own thread. It’s really valuable information but I fear users will not find it down here as the 20th response to a month old thread. Put it in the Tutorials and Solutions category.
I thought I would add this bit to the solution, as it wasn’t obvious to me at first. I had to change the “/” to “%2F” in the above in order to get it to work:
url=jdbc:mysql://127.0.0.1:3306/OpenHAB?useSSL=false&serverTimezone=America%2FNew_York