DocsICP FilingConsole
官方文档
首页

DBVisualizer

更新时间：
复制 MD 格式
我的收藏

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.

  • You have installed a 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.

  • You have obtained a public endpoint for the AnalyticDB for MySQL cluster if you plan to connect over the internet. For more information, see Apply for or release 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 your AnalyticDB for MySQL cluster. You can find the endpoint on the Cluster Information page in the AnalyticDB for MySQL console.
    Database port 3306
    Database

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

    The user name of your database account in the AnalyticDB for MySQL cluster. The account can be a:

    • privileged account

    • standard account
    Database password

    The password that corresponds to the user name.
  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