Connector of Cloud SQL for MySQL do not work for MySQL 8 [167924845]

Fixed

Feature Request

Status Update

No update yet.

Description

ba...@gmail.com

created issue #1

Sep 7, 2020 06:52AM

Dear GCP team,
I just upgrade MySQL on Cloud SQL to version 8 and I need to visualize data of this on Data Studio. However, the current connector does not work for Mysql 8.0.
So could GCP help us on this issue, it's urgent to us.
Thank you very much.

Comments

je...@gmail.com <je...@gmail.com> #2Oct 28, 2020 03:29AM

Project: platform/frameworks/support
Branch: androidx-main

commit b6c7c78f9e7476b468dafe9d5f7dec6794d47f09
Author: Shahd AbuDaghash <shahddaghash@google.com>
Date: Mon Nov 27 11:16:51 2023

Introduce DecayAnimation in AnchoredDraggable

Decay animation allows more realistic settling of a component. This is performed by now passing a `DecayAnimationSpec` parameter to AnchoredDraggable and using it when animating to the target. The new animation implementation will be added in a chain CL.

Bug: 288084801
Test: Tests will be added in a chain CL
Relnote: This change adds a `decayAnimationSpec` parameter to AnchoredDraggable allowing to use decay animation when settling to one of the anchors. The change also includes renaming the existing `animationSpec` to `snapAnimationSpec` to help understanding the use case of each spec.
Change-Id: I44ccd408d919328fd6504d31d8db59cf1d07de43

M compose/foundation/foundation/api/current.txt
M compose/foundation/foundation/api/restricted_current.txt
M compose/foundation/foundation/samples/src/main/java/androidx/compose/foundation/samples/AnchoredDraggableSample.kt
M compose/foundation/foundation/src/androidInstrumentedTest/kotlin/androidx/compose/foundation/anchoredDraggable/AnchoredDraggableGestureTest.kt
M compose/foundation/foundation/src/androidInstrumentedTest/kotlin/androidx/compose/foundation/anchoredDraggable/AnchoredDraggableStateTest.kt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/AnchoredDraggable.kt

https://android-review.googlesource.com/2847074

em...@unito.it <em...@unito.it> #3Nov 2, 2020 03:16PM

Project: platform/frameworks/support
Branch: androidx-main

commit 365993d1a90c27704b71f6bee042a1749314a4b1
Author: Shahd AbuDaghash <shahddaghash@google.com>
Date: Tue Nov 28 10:49:56 2023

Add tests for Animation in AnchoredDraggable

Added tests to check for different settling behaviors.

Bug: 288084801
Test: Added tests to verify behavior.
Change-Id: I369b30c69f7c29f676ae0671fef25c38ff3c74cb

M compose/foundation/foundation/src/androidInstrumentedTest/kotlin/androidx/compose/foundation/anchoredDraggable/AnchoredDraggableStateTest.kt

https://android-review.googlesource.com/2847475

do...@google.com <do...@google.com> #4Nov 11, 2020 01:58AM

Project: platform/frameworks/support
Branch: androidx-main

commit ff1a600df5f4d8ae21a75d8e3e0f24d6c5c2faee
Author: Shahd AbuDaghash <shahddaghash@google.com>
Date: Mon Nov 27 15:51:12 2023

Modify settle function to perform decay animation if possible

When settling, a check will be performed to see if natural decay animation can be used. If not so, a target animation will be used. The consumed velocity is returned to the settle function, which could be used to show an overscroll effect.

Bug: 288084801
Test: Tests will be added in a chain CL.
Relnote: This change introduces a new `animateToWithDecay` function that naturally decays if possible. It takes the target value and the initial velocity. The `animateTo` functions no longer takes a velocity, but passes the available velocity in `lastVelocity` to animation, as it is concerned with reaching the target. If users need to pass a certain velocity for animation, they can use `animateToWithDecay` function.
Change-Id: I465dbd826e3969b784d08c65425f4bbda3de8493

M compose/foundation/foundation/api/current.txt
M compose/foundation/foundation/api/restricted_current.txt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/AnchoredDraggable.kt

https://android-review.googlesource.com/2847576

Message last modified on Nov 11, 2020 02:44AM

ro...@gmail.com <ro...@gmail.com> #5Nov 11, 2020 05:43AM

Project: platform/frameworks/support
Branch: androidx-main

commit 01142ddd5b14eb33e5145c4e72e6619a5c100fe4
Author: Shahd AbuDaghash <shahddaghash@google.com>
Date: Thu Dec 21 12:34:00 2023

Introduce Overscroll in AnchoredDraggable

Adding overscroll support to AnchoredDraggable by giving the ability to pass a customized overscrollEffect object to AnchoredDraggable.

Bug: 288084801
Relnote: An OverscrollEffect has been introduced to allow for custom overscroll effects in anchoredDraggable. To retrieve the consumed velocity after animation, the consumed velocity is returned from the settle function.
Test: Added tests to verify behavior
Change-Id: I100683fe7473b1e5ff317ab22245a2b0a25bd549

M compose/foundation/foundation/api/current.txt
M compose/foundation/foundation/api/restricted_current.txt
M compose/foundation/foundation/integration-tests/foundation-demos/src/main/java/androidx/compose/foundation/demos/AnchoredDraggableDemo.kt
M compose/foundation/foundation/samples/src/main/java/androidx/compose/foundation/samples/AnchoredDraggableSample.kt
A compose/foundation/foundation/src/androidInstrumentedTest/kotlin/androidx/compose/foundation/anchoredDraggable/AnchoredDraggableOverscrollTest.kt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/AnchoredDraggable.kt

https://android-review.googlesource.com/2888106

va...@mylittleadventure.com <va...@mylittleadventure.com> #6Dec 2, 2020 02:56PM

Project: platform/frameworks/support
Branch: androidx-main

commit 0f071d797bccf7eff2a23e408928ca76640af782
Author: Shahd AbuDaghash <shahddaghash@google.com>
Date: Wed Nov 29 18:34:09 2023

Migrates AnchoredDraggable to Modifier.Node

Migrates AnchoredDraggable to Modifier.Node. This helps in adding Overscroll effect in AnchoredDraggable.

Bug: 288084801
Test: Added tests to verify behavior
Change-Id: I3f3338cd71763972c4b70f2e06c97e85285b0035

M compose/foundation/foundation/src/androidInstrumentedTest/kotlin/androidx/compose/foundation/anchoredDraggable/AnchoredDraggableGestureTest.kt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/AnchoredDraggable.kt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/Draggable.kt
M compose/foundation/foundation/src/commonMain/kotlin/androidx/compose/foundation/gestures/Draggable2D.kt

https://android-review.googlesource.com/2852691

lc...@fmlogistic.com <lc...@fmlogistic.com> #7Dec 3, 2020 08:28AM

This issue is marked as fixed, but there is still no replacement for ResistanceConfig.

How should we properly migrate it?

ma...@gmail.com <ma...@gmail.com> #8Dec 6, 2020 03:52AM

Can we document this / update the migration guide?

ss...@gmail.com <ss...@gmail.com> #9Dec 25, 2020 05:07PM

gs...@gmail.com <gs...@gmail.com> #10Jan 4, 2021 09:30PM

gc...@mcnmena.com <gc...@mcnmena.com> #11Jan 7, 2021 05:24AM

+1
How is this still an issue?!

st...@gmail.com <st...@gmail.com> #12Jan 11, 2021 04:58PM

ge...@gmail.com <ge...@gmail.com> #13Jan 28, 2021 08:21PM

+1 plz fix it

re...@kaaman.in <re...@kaaman.in> #14Feb 2, 2021 06:01AM

ca...@gmail.com <ca...@gmail.com> #15Feb 12, 2021 02:34AM

be...@gmail.com <be...@gmail.com> #16Feb 15, 2021 01:41PM

Same problem here. Cannot connect to MySQL 8.0

ra...@gmail.com <ra...@gmail.com> #17Feb 17, 2021 08:04AM

mr...@gmail.com <mr...@gmail.com> #18Feb 17, 2021 10:14PM

[Deleted User] <[Deleted User]> #19Feb 18, 2021 02:15PM

ac...@gmail.com <ac...@gmail.com> #20Feb 19, 2021 12:07AM

l....@vargroup.it <l....@vargroup.it> #21Feb 19, 2021 11:40AM

je...@gmail.com <je...@gmail.com> #22Feb 21, 2021 10:14PM

+1
MySQL 8 has been around for nearly 3 years!

ad...@gmail.com <ad...@gmail.com> #23Feb 24, 2021 12:17PM

fm...@fmlogistic.com <fm...@fmlogistic.com> #24Feb 26, 2021 09:46AM

+1 please update

ra...@gmail.com <ra...@gmail.com> #25Feb 27, 2021 01:22AM

Same here

[Deleted User] <[Deleted User]> #26Feb 27, 2021 02:41PM

Same here

da...@semantic-visions.com <da...@semantic-visions.com> #27Mar 1, 2021 01:06PM

[Deleted User] <[Deleted User]> #28Mar 3, 2021 01:46AM

sk...@ctepl.com <sk...@ctepl.com> #29Mar 4, 2021 04:35PM

jo...@gmail.com <jo...@gmail.com> #30Mar 5, 2021 02:38AM

[Deleted User] <[Deleted User]> #31Mar 5, 2021 11:22PM

th...@gmail.com <th...@gmail.com> #32Mar 9, 2021 06:06AM

fr...@fmlogistic.com <fr...@fmlogistic.com> #33Mar 10, 2021 10:06AM

me...@gmail.com <me...@gmail.com> #34Mar 15, 2021 05:56PM

Same issue +1.

Work around using ProxySQL not applicable.

MySQL 8 has been around for a while now...

ge...@k2labs.net <ge...@k2labs.net> #35Mar 16, 2021 05:07PM

Upgraded from 5.7 to 8 not realizing it would break the integration with Data Studio. Ugh.

+1

ca...@gmail.com <ca...@gmail.com> #36Mar 17, 2021 04:16PM

How is this not at the top of the list to resolve

an...@gmail.com <an...@gmail.com> #37Mar 17, 2021 07:39PM

+1 need support for MySQL 8+

mi...@gmail.com <mi...@gmail.com> #38Mar 19, 2021 12:27AM

[Deleted User] <[Deleted User]> #39Mar 22, 2021 11:03AM

mu...@gmail.com <mu...@gmail.com> #40Mar 22, 2021 12:12PM

pk...@gmail.com <pk...@gmail.com> #41Mar 24, 2021 06:43AM

Message last modified on Mar 24, 2021 06:43AM

sp...@gmail.com <sp...@gmail.com> #42Mar 24, 2021 09:42AM

[Deleted User] <[Deleted User]> #43Mar 24, 2021 11:12AM

a....@re-play.ch <a....@re-play.ch> #44Mar 25, 2021 04:28PM

Message last modified on Mar 25, 2021 04:28PM

[Deleted User] <[Deleted User]> #45Mar 26, 2021 10:57AM

ym...@gmail.com <ym...@gmail.com> #46Mar 27, 2021 02:19PM

Amazing that this does not work yet. 3 Years. No communication. This impacts not only Cloud, but also the normal MySQL connector which also leverages the cloud connector. I'm having serious reservation regarding Google services now.

gm...@sislogica.com <gm...@sislogica.com> #47Mar 30, 2021 08:50PM

sc...@fairmounttire.com <sc...@fairmounttire.com> #48Mar 30, 2021 10:22PM

ll...@fmlogistic.com <ll...@fmlogistic.com> #49Mar 31, 2021 09:30AM

kn...@google.com <kn...@google.com> Apr 1, 2021 08:19PM

Assigned to gc...@google.com.

ym...@gmail.com <ym...@gmail.com> #50Apr 5, 2021 04:42PM

It is now (1 April 2021) assigned to someone (gc..@google.com); hopefully this individual also understands that this (167924845) issue is related to / ifs blocking at least issues 153110437, 146322457, 183632458 and is able to communicate with the appropriate teams. See comments on

https://issuetracker.google.com/183632458

gs...@gmail.com <gs...@gmail.com> #51Apr 7, 2021 10:06AM

🤞

rm...@google.com <rm...@google.com> #52Apr 9, 2021 09:46PM

Reassigned to rm...@google.com.

Hi everyone,

We're actively working on updating our MySQL driver to support connecting to MySQL 8. Updating this driver affects not only Data Studio but also several other Google products and services, and requires applying and validating several patches, so we appreciate your patience as we work through this. We anticipate a few more weeks to complete this work and roll out the driver update.

os...@mexrentacar.com <os...@mexrentacar.com> #53Apr 12, 2021 01:59AM

+1

I have a new mysql version (8.0) and my data studios can not connect with that server

ki...@adopstar.com <ki...@adopstar.com> #54Apr 15, 2021 03:23PM

av...@gmail.com <av...@gmail.com> #55Apr 16, 2021 08:15AM

Looking forward to this!

ca...@weroad.com <ca...@weroad.com> #56Apr 20, 2021 11:22AM

jf...@gmail.com <jf...@gmail.com> #57Apr 25, 2021 11:52PM

zl...@google.com <zl...@google.com> #58Apr 26, 2021 07:37PM

Marked as fixed, reassigned to zl...@google.com.

MySQL 8 should be supported now. Please check. Thanks.

ac...@servehcp.com <ac...@servehcp.com> #59Apr 26, 2021 09:19PM

MySql Connector now works for a mysql 8! Thank you!!

ge...@k2labs.net <ge...@k2labs.net> #60Apr 26, 2021 09:46PM

Hooray! Data Studio now works with Cloud SQL Connector & MySQL 8 🙌

gs...@gmail.com <gs...@gmail.com> #61Apr 27, 2021 10:06AM

I can confirm that is working 👍

Bravo, team! 👏