Connect via Standard Connection

This document describes how to connect to your TiDB Cloud cluster via standard connection. The standard connection exposes a public endpoint with traffic filters, so you can connect to your TiDB cluster via a SQL client from your laptop.

The standard connection is available to both Serverless Tier and Dedicated Tier.

Serverless Tier

To connect to a Serverless Tier cluster via standard connection, perform the following steps:

1. Navigate to the Clusters page, and then click the name of your target cluster to go to its overview page.

2. Click Connect in the upper-right corner. A connection dialog is displayed.

3. In the dialog, select your preferred connection method and operating system to get the corresponding connection string.

4. If you have not set a password yet, click Create password to generate a random password. The generated password will not show again, so save your password in a secure location.

5. Connect to your cluster with the connection string.

   Note

   • When you connect to a Serverless Tier cluster, you must include the prefix for your cluster in the user name and wrap the name with quotation marks. For more information, see User name prefix.
   • Serverless Tier clusters only support TLS connection. For more information, see TLS Connection to Serverless Tier.

Dedicated Tier

To connect to a Dedicated Tier cluster via standard connection, perform the following steps:

1. Open the overview page of the target cluster.

   1. Log in to the TiDB Cloud console and navigate to the Clusters page of your project.

      Tip

      If you have multiple projects, you can switch to the target project in the left navigation pane of the Clusters page.

   2. Click the name of your target cluster to go to its overview page.

2. Click Connect in the upper-right corner. A connection dialog is displayed.

3. Create a traffic filter for the cluster. Traffic filter is a list of IPs and CIDR addresses that are allowed to access TiDB Cloud via a SQL client.

   If the traffic filter is already set, skip the following sub-steps. If the traffic filter is empty, take the following sub-steps to add one.

   1. Click one of the buttons to add some rules quickly.

      • Add My Current IP Address
      • Allow Access from Anywhere

   2. Provide an optional description for the newly added IP address or CIDR range.

   3. Click Create Filter to confirm the changes.

4. Under Step 2: Download TiDB cluster CA in the dialog, click Download TiDB cluster CA for TLS connection to TiDB clusters. The TiDB cluster CA supports TLS 1.2 version by default.

   Note

   • The TiDB cluster CA is only available for Dedicated Tier clusters.
   • Currently, TiDB Cloud only provides the connection strings and sample code for these connection methods: MySQL, MyCLI, JDBC, Python, Go, and Node.js.

5. Under Step 3: Connect with a SQL client in the dialog, click the tab of your preferred connection method, and then refer to the connection string and sample code on the tab to connect to your cluster.

   Note that you need to use the path of the downloaded CA file as the argument of the --ssl-ca option in the connection string.

What's next

After you have successfully connected to your TiDB cluster, you can explore SQL statements with TiDB.