Connect Google Data Studio to Local Mysql Server

Question

I have started using Google's Data Studio I found it very easy to turn the Excel data into Intuitive Business Dashboards with little or no coding skills.

But I have a problem here, whenever I try to connect to Mysql DB (running on my local system) I'm facing error.

Connection Details:

Error Message:

I tried googling the Error Code but No luck.

But I'm able to access the local Mysql Server from Mysql Workbench.

What is that I am missing here? Data Studio Heros?

Thanks in advance.

Answer 1

Google Data Studio operates on the Web, thus does not have access to your personal local network. However,

• You may make you MySQL db Engine accessible to the web by changing the bind-address parameter (See on MySQL Workbench, Instance > Option File > Networking > General > bind-address) to 0.0.0.0.

• You also need to create a new user allowed to connect from Hosts Matching %, since Google Data Studio servers are using a dozen of different IP addresses (https://support.google.com/datastudio/answer/7088031?hl=en)

Please refer to this question: How to make mySQL database at my local accessible from different machines?

Please note that this is a bad practice to open an access to your personal computer and you may instead want to use a MySQL or MariaDB cloud service such as https://console.cloud.google.com/launcher/details/bitnami-launchpad/mariadb