Skip to content

Latest commit

 

History

History
190 lines (110 loc) · 9.62 KB

dev-guide-gui-datagrip.md

File metadata and controls

190 lines (110 loc) · 9.62 KB
title summary
Connect to TiDB with JetBrains DataGrip
Learn how to connect to TiDB using JetBrains DataGrip. This tutorial also applies to the Database Tools and SQL plugin available in other JetBrains IDEs, such as IntelliJ, PhpStorm, and PyCharm.

Connect to TiDB with JetBrains DataGrip

TiDB is a MySQL-compatible database, and JetBrains DataGrip is a powerful integrated development environment (IDE) for database and SQL. This tutorial walks you through the process of connecting to your TiDB cluster using DataGrip.

Note:

This tutorial is compatible with TiDB Cloud Serverless, TiDB Cloud Dedicated, and TiDB Self-Managed.

You can use DataGrip in two ways:

This tutorial mainly focuses on the standalone DataGrip IDE. The steps of connecting to TiDB using the JetBrains Database Tools and SQL plugin in JetBrains IDEs are similar. You can also follow the steps in this document for reference when connecting to TiDB from any JetBrains IDE.

Prerequisites

To complete this tutorial, you need:

If you don't have a TiDB cluster, you can create one as follows:

If you don't have a TiDB cluster, you can create one as follows:

Connect to TiDB

Connect to your TiDB cluster depending on the TiDB deployment option you've selected.

  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. Ensure the configurations in the connection dialog match your operating environment.

    • Connection Type is set to Public
    • Branch is set to main
    • Connect With is set to DataGrip
    • Operating System matches your environment.
  4. Click Generate Password to create a random password.

    Tip:

    If you have created a password before, you can either use the original password or click Reset Password to generate a new one.

  5. Launch DataGrip and create a project to manage your connections.

    Create a project in DataGrip

  6. In the newly created project, click + in the upper-left corner of the Database Explorer panel, and select Data Source > Other > TiDB.

    Select a data source in DataGrip

  7. Copy the connection string from the TiDB Cloud connection dialog. Then, paste it into the URL field, and the remaining parameters will be auto-populated. An example result is as follows:

    Configure the URL field for TiDB Cloud Serverless

    If a Download missing driver files warning displays, click Download to acquire the driver files.

  8. Click Test Connection to validate the connection to the TiDB Cloud Serverless cluster.

    Test the connection to a TiDB Cloud Serverless clustser

  9. Click OK to save the connection configuration.

  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 connection dialog, select Public from the Connection Type drop-down list, and then click CA cert to download the CA certificate.

    If you have not configured the IP access list, click Configure IP Access List or follow the steps in Configure an IP Access List to configure it before your first connection.

    In addition to the Public connection type, TiDB Dedicated supports Private Endpoint and VPC Peering connection types. For more information, see Connect to Your TiDB Dedicated Cluster.

  4. Launch DataGrip and create a project to manage your connections.

    Create a project in DataGrip

  5. In the newly created project, click + in the upper-left corner of the Database Explorer panel, and select Data Source > Other > TiDB.

    Select a data source in DataGrip

  6. Copy and paste the appropriate connection string into the Data Source and Drivers window in DataGrip. The mappings between DataGrip fields and TiDB Cloud Dedicated connection string are as follows:

    DataGrip field TiDB Cloud Dedicated connection string
    Host {host}
    Port {port}
    User {user}
    Password {password}

    An example is as follows:

    Configure the connection parameters for TiDB Cloud Dedicated

  7. Click the SSH/SSL tab, select the Use SSL checkbox, and input the CA certificate path into the CA file field.

    Configure the CA for TiDB Cloud Dedicated

    If a Download missing driver files warning displays, click Download to acquire the driver files.

  8. Click the Advanced tab, scroll to find the enabledTLSProtocols parameter, and set its value to TLSv1.2,TLSv1.3.

    Configure the TLS for TiDB Cloud Dedicated

  9. Click Test Connection to validate the connection to the TiDB Cloud Dedicated cluster.

    Test the connection to a TiDB Cloud Dedicated cluster

  10. Click OK to save the connection configuration.

  1. Launch DataGrip and create a project to manage your connections.

    Create a project in DataGrip

  2. In the newly created project, click + in the upper-left corner of the Database Explorer panel, and select Data Source > Other > TiDB.

    Select a data source in DataGrip

  3. Configure the following connection parameters:

    • Host: The IP address or domain name of your TiDB Self-Managed cluster.
    • Port: The port number of your TiDB Self-Managed cluster.
    • User: The username to use to connect to your TiDB Self-Managed cluster.
    • Password: The password of the username.

    An example is as follows:

    Configure the connection parameters for TiDB Self-Managed

    If a Download missing driver files warning displays, click Download to acquire the driver files.

  4. Click Test Connection to validate the connection to the TiDB Self-Managed cluster.

    Test the connection to a TiDB Self-Managed cluster

  5. Click OK to save the connection configuration.

Next steps

Need help?

Ask questions on TiDB Community, or create a support ticket.

Ask questions on TiDB Community, or create a support ticket.