Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
Windows
Description
Google Apps Script https://script.google.com/home/ have built-in JDBC connector used to connect to MySQL. There are couple of tutorials out there showing how to do it on some free hosting MySQL databases.
I want to test and allow to connect to my local database, because there are no tutorials MariaDB and Google Apps what could be great topic for the blog.
My work is done on Windows machine with 10.7 MariaDB.
- 1) I tested my port forwarding, where the port 3306 of the public IP is forwarded to my local IP address (this settings is done on router).
- 2) In mariadb server bind_address is set to 0.0.0.0
- 3) Tested with telnet -> telnet <publicIP> 3306 works
- 4) Created user <user>at<publicIP> and granted all
- 5) Before we go to the Apps Script, we can check connection in Google Data studio https://datastudio.google.com/ with Basic or JDBC connector.
In my case, this step doesn't work.