All Products
Search

This Product

    AnalyticDB:SQL WorkBench/J

    Document Center

    AnalyticDB:SQL WorkBench/J

    Last Updated:Aug 24, 2026

    SQL WorkBench/J is a DBMS-independent, cross-platform SQL query and analysis tool. You can use SQL WorkBench/J to connect to an AnalyticDB for MySQL cluster.

    Prerequisites

    Before you use SQL WorkBench/J, complete the following preparations.

    • Review the compatibility between SQL WorkBench/J and AnalyticDB for MySQL. For more information, see Compatibility overview.
    • Install the MySQL JDBC driver.
    • Install SQL WorkBench/J. Add the IP address of the device on which SQL WorkBench/J is installed to the whitelist of your AnalyticDB for MySQL cluster. For more information, see Configure a whitelist.
    • If you need to connect to an AnalyticDB for MySQL cluster over the Internet, apply for a public endpoint first. For more information, see Apply for and release a public endpoint.

    Usage notes

    To enable PrepareStatement in SQL WorkBench/J, see Enable PrepareStatement for clients in different programming languages.

    Procedure

    1. Open SQL WorkBench/J and choose File > Manage Drivers.
      Note When you use SQL WorkBench/J for the first time, you must add the JDBC driver and JAR file. For subsequent uses, you can skip to Step 3.
    2. On the Manage drivers page, select MySQL as the driver, add the driver JAR file, and then click OK.
      Set Classname to com.mysql.jdbc.Driver and Sample URL to jdbc:mysql://hostname:port/name_of_database.
    3. Choose File > Connect window. On the Select Connection Profile page, configure the following parameters.
      Parameter Description
      New profile Enter a name for the connection profile for easy management.
      Driver Select MySQL.
      URL

      The endpoint used to connect to the AnalyticDB for MySQL cluster. You can view the connection information on the Cluster Information page of the console.
      Username

      The account created in the AnalyticDB for MySQL cluster:

      • Privileged account
      • Standard account
      Password

      The password for the account.
    4. After you configure the preceding parameters, click Test to test the connectivity. After the test passes, click OK to connect to the AnalyticDB for MySQL cluster.