MySQL is one of popular database on linux platform, and I would like to share how to use MySQL database as a source on Google Data Studio.
Followings are the pre-condition you need to prepare before setup your database as a source
- 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: Change MySQL port number
Note that you cannot put "localhost", because Google Data Studio server needs to connect to your MySQL server remotely for getting necessary data - meaning it should be public IP address.
If everything above is ready, let us start connection by MySQL Connector.