Wrangler Mysql basic connection fails for mysql8

Description

On my mysql8 instance, I need to use the advanced tab when creating the wrangler connection and specify a jdbc connection string with '?serverTimezone=UTC' in the connection string. This is not a friendly user experience, perhaps that should be the default for the basic view.

Release Notes

None

Activity

Show:

Nick Briggs February 11, 2021 at 9:45 PM

Would you be able to try with the newest version 8 driver?

Nick Briggs February 11, 2021 at 9:45 PM

Using MySQL 8.0.22 and driver 8.0.23, I can’t reproduce the issue. Creating a connection with the basic tab works fine.

Albert Shau February 11, 2021 at 6:42 PM

it’s been a while, but I believe I was using 8.

Nick Briggs February 11, 2021 at 1:21 AM
Edited

What driver version did you use? I got connection errors with MySQL 8 and 5.1.39, but was able to connect to my DB with driver version 5.1.49 using the Basic UI.

Yaojie Feng February 9, 2021 at 9:00 PM

This is a UI bug since the config is hardcoded in UI right now

Cannot Reproduce
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Components

Sprint

Fix versions

Priority

Created April 9, 2020 at 6:35 AM
Updated February 23, 2021 at 12:58 AM
Resolved February 23, 2021 at 12:58 AM