18/03/2021 - nodejs mysql cloud database
1. google cloud console, google cloud trial and create test app 2. google cloud sql console, get credentials 3. installing mysql, create connection in workbench and test queries 4. npm mysql and creating mysql connection and queries for nodejs server 5. resources - nodejs mysql, sql queries you need to activate the google cloud free trial, create a test app go to google cloud console and click the dropdown create new project go to google cloud sql console https://console.cloud.google.com/sql create/choose an app>create instance>choose btwn mysql etc click button to enable engine api ... set user password, click button to create instance white list your public ip address (google what's my ip address). click save to connect to cloud sql in mysql workbench you need mysql community server https://dev.mysql.com/downloads/mysql/ credentials you can add user and change password https://cloud.google.com/sql/docs/mysql/admin-tools#workbench after you have installed server...