Skip to content
Google Cloud

MySQL Cloud Server

För att få in specifik data från MySQL-databas i molnet:

Screenshot 2022-08-08 at 13.03.02.png

Screenshot 2022-08-08 at 13.03.17.png

Screenshot 2022-08-08 at 13.03.33.png

Välj MySQL
Skapa en ny MySQL-Instans på Google Cloud

Screenshot 2022-08-08 at 13.14.59.png

Screenshot 2022-08-08 at 13.19.21.png
Screenshot 2022-08-08 at 13.28.25.png


Screenshot 2022-08-08 at 13.28.37.png
Screenshot 2022-08-08 at 13.28.50.png
Screenshot 2022-08-08 at 13.29.31.png
Screenshot 2022-08-08 at 13.35.10.png
Screenshot 2022-08-08 at 13.29.47.png
Screenshot 2022-08-08 at 13.33.13.png
Screenshot 2022-08-08 at 13.33.55.png
Screenshot 2022-08-08 at 13.35.31.png
Screenshot 2022-08-08 at 13.35.42.png
Screenshot 2022-08-08 at 13.35.53.png
Screenshot 2022-08-08 at 13.36.23.png
Screenshot 2022-08-08 at 13.36.40.png

För att koppla upp sig mot databasen. Välj “Connection” i sidomenyn, sedan “authorized networks” och ADD NETWORK.
Screenshot 2022-08-08 at 13.38.18.png
Screenshot 2022-08-08 at 13.40.15.png
Screenshot 2022-08-08 at 13.40.32.png
Screenshot 2022-08-08 at 13.40.44.png
Screenshot 2022-08-08 at 13.40.54.png
Screenshot 2022-08-08 at 13.41.44.png
Screenshot 2022-08-08 at 13.41.49.png

Nå MySQL-servern Från Workbench:

Add New instance ( x)-knappen och fyll i Din publika IP, användarnamn och lösenord.
Screenshot 2022-08-08 at 13.43.44.png




Koppla till MySQL-miljön från BigQuery:

Screenshot 2022-08-08 at 14.15.15.png

sandbox-project-358807:europe-north1:student-mysql-installation
Screenshot 2022-08-08 at 14.15.05.png


Screenshot 2022-08-08 at 14.19.10.png

Screenshot 2022-08-08 at 14.19.20.png

Den ska sedan synas direkt i listan
Screenshot 2022-08-08 at 14.20.03.png
Screenshot 2022-08-08 at 14.19.54.png

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.