# 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/l8mdwsxUpx7KydOVG25y/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/LxY6ENWuOnjq7v6RrNME/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/vWcmCXh1C23VfvyZi8lx/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/3x8zpUkvd2KzOAZXoIhe/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/bl0DXjyeFWOAU3V2HsLd/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/wvdka2Xp1Go7Ej7Lw5pt/image.png" 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://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/AyqeGXpkiSBAUBzmSL5n/image.png" alt="" width="563"><figcaption><p>After establishing a connection</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.tellius.com/tellius-5.4/data/create-new-datasource/connecting-to-google-cloud-sql/connecting-to-a-mysql-cloud-sql-instance.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
