Wrangler Mysql basic connection fails for mysql8
Description
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 AMEdited
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
Details
Assignee
Nick BriggsReporter
Albert ShauComponents
Sprint
None
Fix versions
Priority
MajorCreated April 9, 2020 at 6:35 AM
Updated February 23, 2021 at 12:58 AM
Resolved February 23, 2021 at 12:58 AM
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.