将Google Data Studio连接到本地Mysql Server [英] Connect Google Data Studio to Local Mysql Server

问题描述

我已经开始使用Google的Data Studio，我发现将Excel数据转换为具有很少或没有编程技能的Excel仪表板非常容易。

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.

但是在这里，每当我尝试连接到Mysql DB（在本地系统上运行）时，我都会遇到错误。

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

连接详细信息：

错误消息：

我尝试搜索错误代码，但是没有运气。

I tried googling the Error Code but No luck.

但是我可以从Mysql Workbench访问本地Mysql Server。

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

我在这里想念什么？ Data Studio Heroes？

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

预先感谢。

推荐答案

随便如上所述，最佳做法是使用Google Cloud本身之类的云服务来托管您的MySql数据库，然后在那里建立连接。

As Will mentioned above, it's best practise to use cloud service such as Google Cloud itself to host your MySql database and then take the connection there.

将数据库连接到Data Studio时，需要为其使用的所有IP地址打开防火墙。您可以在此支持文章的底部找到IP的完整列表 https：/ /support.google.com/datastudio/answer/7088031?hl=zh_CN

When you connect your database to Data Studio you need to open firewall for all the IP addresses it uses. You can find the whole list of IPs on the bottom of this support article https://support.google.com/datastudio/answer/7088031?hl=en

如果您的数据库位于防火墙后面，您将需要打开对
以下所有IP地址的访问权限。 Data Studio
使用它们来连接和查询您的MySql数据库。

If your database is behind a firewall, you will need to open access to the all of the following IP addresses. These are used by Data Studio to connect to and query your MySql database.

这篇关于将Google Data Studio连接到本地Mysql Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！