> For the complete documentation index, see [llms.txt](https://gdgcloud-taipei.gitbook.io/google-cloud-platform-in-practice/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://gdgcloud-taipei.gitbook.io/google-cloud-platform-in-practice/google-cloud-shang-de-chu-cun-fu-wu/cloudsql/jian-li-cloudsql.md).

# 建立CloudSQL

本部分以指令方式描述建立CloudSQL之過程，相關設定也支援Web Console上的操作以及RESTful API的操作方式。

Step1: 檢視可使用的CloudSQL型號

```
$ gcloud sql tiers list
```

![](https://lh5.googleusercontent.com/eJLq86Gv0B177efTbWBFtSWSsGtZyiawFq6WZvMuYXNKrTmkbAN0eqUXBXlFghkH2LR4E2unNwj6kHVFZTV9wpWQ-rWhzrrsuXQgZPsF5RbJfSt04T7ZigRu4XHcJIlqS9oCgQd4)

Step2: 選用所需要的型號來建立CloudSQL Instance

```
$ gcloud beta sql instances create [INSTANCE_NAME] \
  --tier=[MACHINE_TYPE] \
  --activation-policy=ALWAYS
```

Step3: 修改CloudSQL預設密碼

```
$ gcloud sql instances set-root-password [INSTANCE_NAME] --password [PASSWORD]
```

Step4: 查詢Cloud SQL的資訊

```
gcloud beta sql instances describe [INSTANCE_NAME]
```

Step5: 由於Apps Script為Gsuite上的應用服務，因此我們需要授權Apps Script的機器網段來存取CloudSQL服務

```
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 66.249.80.0/20
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 64.233.160.0/19
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 66.102.0.0/20
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 64.18.0.0/20
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 72.14.192.0/18
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 74.125.0.0/16
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 173.194.0.0/16
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 207.126.144.0/20
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 209.85.128.0/17
gcloud sql instances patch [INSTANCE_NAME] --assign-ip --authorized-networks 216.239.32.0/19
```

以上，如果設定無誤，則可以使用相對應的Client工具來連線您的資料庫。