# Connecting to a MySQL Cloud SQL Instance

### **Prerequisites**

Ensure that you have an existing GCP Cloud MySQL instance.

### **Steps to follow**

1. Go to [this link](http://console.cloud.google.com/sql/instances) where the list of instances will be displayed.
2. Select the required instance from the existing list.
3. If you do not have an existing instance, click on **Create Instance** to create one.
4. On the **Create an instance** page, choose MySQL database engine from the list.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2F3ai5vDbgNnQzouH5wTbh%2Fimage.png?alt=media&#x26;token=112dc41c-abfa-442c-903b-d4df07b71549" alt=""><figcaption><p>Creating an instance</p></figcaption></figure>

5. In the **Primary Instance** pane on the left side, select **Connections** and click on the **Networking** tab.
6. Under **Instance IP assignment**, click on the **Public IP** checkbox.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FWE9rJqzeaKh7CibWPTBX%2Fimage.png?alt=media&#x26;token=cf0b5d9f-b21d-4a49-8b90-2a254438598b" alt="" width="563"><figcaption><p>Selecting public IP</p></figcaption></figure>

7. Click on **Add a network** under the **Authorized networks** section. **New network** section will open.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FlgiulynEo9XbJXh14o9v%2Fimage.png?alt=media&#x26;token=8f4ff408-0fe5-4a99-b76a-188e5f8e8e81" alt="" width="563"><figcaption><p>Adding a new network</p></figcaption></figure>

8. Provide a **Name** and **IP address** in the respective fields. Click on **Done** and click on **Save**.

{% hint style="info" %}
Please note that the IP address in CIDR notation will be provided by the Tellius team.&#x20;
{% endhint %}

9. Under the **Security** tab, ensure that the checkbox **Allow only SSL connections** is left unchecked.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FUALY09d6YrJqfJbcU91C%2Fimage.png?alt=media&#x26;token=005b253d-0a7b-40b9-a1f2-50ab89961589" alt="" width="563"><figcaption><p>Unchecking "Allow only SSL connections"</p></figcaption></figure>

{% hint style="info" %}
If “*Only secured connections are allowed to connect to this instance*” is displayed, click on **Allow unsecured connections**.\
\
If “*Unsecured connections are allowed to connect to this instance*” is displayed, you do not need to change anything.<br>
{% endhint %}

10. From the GCP console, please note the following details, as they will be required when setting up the connection on the Tellius platform:

* Under the **Summary** tab, copy the **Public IP address**.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FNsqIi540m6H5qF68rZbz%2Fimage.png?alt=media&#x26;token=aa3806b1-1db9-44c7-8486-9e501104387b" alt="" width="563"><figcaption><p>Copying the public IP address</p></figcaption></figure>

* In the **Primary Instance** pane, select **Databases**. From the list of databases, copy the name of the required database.
* In the **Primary Instance** pane, select **Users**. From the list of users, copy the name of the required user.

11. In the Tellius platform, navigate to **Data → Connect → Create New → MySQL**.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FN9nNLSFbgsJOB3lC51MV%2Fimage.png?alt=media&#x26;token=2505a6d9-99d7-4b31-a855-ae7981ebe2f5" alt="" width="563"><figcaption><p>Data → Connect → Create New → MySQL</p></figcaption></figure>

12. Paste the IP address in the **Hostname** field.
13. Provide the default port number 3306 in the **Port** field.
14. Paste the copied database name in the **Database** field.
15. Paste the copied user name in the **User** field.
16. Provide the required password in the **Password** field.
17. Click on **Save and Browse Host** (or **Browse Host** if you are using an already established connection). The list of tables from the data source will be displayed on the right side.

<figure><img src="https://977923713-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FJHwf1QFuv1BRPzfSnL2Z%2Fuploads%2FBuP5IhksAr3VHEW5fSC3%2Fimage.png?alt=media&#x26;token=1c5b9bcb-b352-4d6e-ba5a-ff93194ed24d" alt="" width="563"><figcaption><p>After establishing a connection</p></figcaption></figure>
