Google Cloud SQLのセットアップ

gcloud sql instances describe cnfbox-dev-store

[koya-mac:~]$ ./cloud_sql_proxy -instances="cnfbox-dev:us-central1:cnfbox-dev-store"=tcp:3306
2020/01/07 13:48:02 Rlimits for file descriptors set to {&{8500 9223372036854775807}}
2020/01/07 13:48:03 Listening on 127.0.0.1:3306 for cnfbox-dev:us-central1:cnfbox-dev-store
2020/01/07 13:48:03 Ready for new connections

[koya-mac:~]$  gcloud sql databases create dev1 --instance="cnfbox-dev-store"
Creating Cloud SQL database...done.
Created database [dev1].
instance: cnfbox-dev-store
name: dev1
project: cnfbox-dev

[koya-mac:~]$ gcloud sql databases list --instance=cnfbox-dev-store
NAME                CHARSET  COLLATION
information_schema  utf8     utf8_general_ci
dev1                utf8     utf8_general_ci
mysql               utf8     utf8_general_ci
performance_schema  utf8     utf8_general_ci
sys                 utf8     utf8_general_ci

gcloud sql users set-password root --host=% --instance=cnfbox-dev-store --prompt-for-password

gcloud sql users create dev1-user --host=% --instance=cnfbox-dev-store --password=[PASSWORD]

mysql -u root -h 34.66.32.43 -p

create table config (
  id INT PRIMARY KEY AUTO_INCREMENT, 
  content json DEFAULT NULL
);