DocsICP FilingConsole
Documentation
Home Page AnalyticDB AnalyticDB for MySQL User Guide Database connection Connect a client to AnalyticDB MySQL DBVisualizer

DBVisualizer

Updated at:
Copy as MD
My Favorites

This topic describes how to connect to an AnalyticDB for MySQL cluster using DBVisualizer.

Prerequisites

Complete the following prerequisites.
  • Review the compatibility overview for DBVisualizer and AnalyticDB for MySQL.
  • Install the MySQL JDBC driver.
  • Install DBVisualizer.
  • Add the IP address of the device running DBVisualizer to the whitelist of your AnalyticDB for MySQL cluster. For more information, see Configure a whitelist.
  • To connect to the AnalyticDB for MySQL cluster over the Internet, request a public endpoint.

Procedure

  1. Open DBVisualizer. In the menu bar, click Tools > Connection Wizard. In the New Connection Wizard, enter a name for the connection.
  2. Click Next and select MySQL as the Database Driver.
  3. Click Next and configure the connection parameters.
    Parameter Description
    Notes A description of the connection.
    Database server

    The endpoint of the AnalyticDB for MySQL cluster. You can view the connection information on the Cluster Information page in the console.
    Database port 3306
    Database

    The name of the database in the AnalyticDB for MySQL cluster.
    Database userid

    The account that is created in the AnalyticDB for MySQL cluster:

    • Privileged account.

    • Standard account.
    Database password

    The password that corresponds to the account.
  4. After you configure the parameters, click Ping Server to test the connection. If the test is successful, click Finish.

    Once connected to the AnalyticDB for MySQL cluster, you can use DBVisualizer to manage your data.

Previous：DBeaverNext：Navicat