Versions Compared

Old Version 3

changes.mady.by.user Chun Kang

Saved on

compared with

New Version Current

changes.mady.by.user Chun Kang

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • MySQL Database (database, user, password)
  • MySQL connection port needs to be opened if your server is under firewall. Default port number is 3306, but recommend you to use different number if you can change it. Reference: How to change Change MySQL port number?
If you ready above, you can set its JDBC URL as following

...

STEP 1. Select "Data Source" and click "+" to create new data source on Google Data Studio
Image Modified
STEP 2. Select ""Cloud SQL for MySQL" to setup a data source from MySQL.
Image Modified
STEP 3. Click "Authorize" and "Allow"
Image Modified
Image RemovedImage Added
STEP 4. Put the connection information on Basic and 
Image Modified
Image Modified
STEP 5. You will be able to see table list like below. Mine has only one table below:
Image Modified
STEP 6. If everythig is okay, just click "Create Report" and make your own report.
Image Modified
Image Modified
Image Modified