Keywords: LAMP/MAMP/WAMP - AWS - How to - Other
I am trying to connect to my database from Google Data Studio (GDS). I am aware that this is a security issue, but I do not believe an SSH Tunnel is provided as an option.
-- opened the port 3306 in Amazon Lightsail
-- changed the bind address from 127.0.0.1 to 0.0.0.0
-- updated the database user from 'username'@'localhost' to 'username'@'%'
-- updated the database table host from 'localhost' to '%'
However, when I provide GDS with the IP Address, Port, Database, Username, and Password, I get an error message., "Sorry, we encountered an error and were unable to complete your request."
I'm not sure what else I need to do in order to get Google Data Studio to connect to my database.