# 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/s16h5onryWtbaHwBa10b/blobs/MBQZxk417SVO1OJCG1La/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/s16h5onryWtbaHwBa10b/blobs/T70c8Ua7bl6Ueo5hPCrN/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/s16h5onryWtbaHwBa10b/blobs/dlQWfHLzVTNRsML2UDLZ/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/s16h5onryWtbaHwBa10b/blobs/NCmOJtxxBcxVPiYnzlGi/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/s16h5onryWtbaHwBa10b/blobs/itHVxxuUl4pnatdzZrgX/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/s16h5onryWtbaHwBa10b/blobs/E0e5Cj90EIOK0sHUGJOl/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/s16h5onryWtbaHwBa10b/blobs/b4mJx3pmcCUPPA4kMln4/image.png" alt="" width="563"><figcaption><p>After establishing a connection</p></figcaption></figure>
