Data Studio
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Unable to connect DataStudio to MySQL data on hosting company

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

I've tried to authenticate to my MySQL database (hosted with CloudAccess) but the authentication fails.

I'm able to connect locally to that remote database (using MySQL Workbench with exact same connection data).

I've also confirmed with CloudAccess that they are not blocking datastudio access.

 

Anyone have any ideas what might be the cause?

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

having the same issue. Am able to connect to mysql from other sources but it's not authenticating from Google Studio.

 

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Same problem here. Can't connect, mysql works fine from other sources. No authentication from datastudio. The ip's in

 

https://support.google.com/360suite/datastudio/answer/7088031?hl=en

Are cleared for connection to my db.

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I'm also having the same problem. Has anyone found a solution or is this a bug?

Re: Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Same problem here! Any suggestions?

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Same issue here. I can connect using a Windows App such as HeidiSQL but can't via Data Studio.

What IP addresses are people whitelisting? Is there a hostname we can use for Data Studio rather than having to enter in dozens of IP addresses?

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

the same issue - hosts added, credentials are correct and... "Access denied, please check your username and password."

Unable to connect DataStudio to MySQL data on hosting company

[ Edited ]
Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Same problem here, all ip's are cleared. 

Credentials checked and correct. 

 

But still the connection is not working.

 

Any solutions?

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

Having the exact same problem. I'm on Hostgator cloud and can connect to mysql database through MySQL workbench without any problems. I'm also able to use other programs to connect to my database externally without any problems. I know the password/username are right. I have also added the I.P.s from the document here to make sure that wasn't the problem.

 

Any suggestion on how to fix this? Or is there a preferred Google data studio provider that would integrate correctly?

Unable to connect DataStudio to MySQL data on hosting company

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

I had everything working up until last week when my reports would no longer connect to the database.

 

How do I go about adding the IPs? Is this for my IT team?