...
- 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
STEP 2. Select ""Cloud SQL for MySQL" to setup a data source from MySQL.
STEP 3. Click "Authorize" and "Allow"
STEP 4. Put the connection information on Basic and
STEP 5. You will be able to see table list like below. Mine has only one table below:
STEP 6. If everythig is okay, just click "Create Report" and make your own report.