hi
i try to connect google data studio to mysql
but it fail
already allow 12 ip from google
already setup mysql remote connection
any idea or tutorial ??
tahnks !!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×Finally i was able to connect data studio and mysql server inside a DO droplet :
1.- Allow mysql to accept external connections:
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
look for
bind-address = 127.0.0.1
change it to
bind-address = 0.0.0.0
2.- restart the server to apply the changes:
sudo systemctl restart mysql
3.- Create a new admin user for mysql:
Question
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
4.- Open the ports:
sudo ufw allow mysql
That’s all folks now go to datastudio and setup the new connection with que data that you just create (New admin user).
Atte. Max Mussuto
This is warning against opening up your database port for the whole world to connect and try out passwords. Recommended is to apply a IP access limit in the firewall that only includes the IP’s from Google Data Studio and your own IP’s. The list of IP’s can be found on the bottom of this article: https://support.google.com/datastudio/answer/7088031
Secondly, it is recommended to setup SSL encryption between the database and Google Data Studio. Without encryption all your data will can be read by any network device in the middle.
I’m working on trying to figure it out. I know I need to set up to allow remote access but I must be missing some steps because it still isn’t working.
me too
i already allow remote access
but it still not working lol
please tell me if yours is working
thanks q
Has anyone figured this out yet?