You can connect to an AnalyticDB for MySQL cluster by using Data Management (DMS), a MySQL client such as Navicat for MySQL, DBeaver, DBVisualizer, and SQL Workbench/J, a business intelligence (BI) visualization tool, or the MySQL command line tool. You can also enter information such as the endpoint, the port, and the account of an AnalyticDB for MySQL cluster in your application to connect to the cluster.

Background information

DMS is a graphical data management tool that is provided by Alibaba Cloud. You can use DMS to manage relational databases and NoSQL databases. DMS provides features such as data management, SQL operations, data import and export, database cloning, database performance optimization, and security audit.

Use DMS to connect to an AnalyticDB for MySQL cluster

  1. Log on to the AnalyticDB for MySQL console.
  2. In the upper-left corner of the page, select the region where the target cluster resides.
  3. In the left-side navigation pane, click Clusters.
  4. On the V3.0 Clusters tab, click the target Cluster ID.
  5. In the upper-right corner of the Cluster Information page, click Log On to Database.
  6. Enter the information required to log on to the AnalyticDB for MySQL cluster.
    Log on to the cluster
    • 1. Enter the VPC endpoint and VPC port of the cluster in the <VPC endpoint>:<VPC port number> format. You can view the connection information on the Cluster Information page.
    • 2. Enter a database account of the cluster.
    • 3. Enter the password of the database account.
  7. Click Log On.
    Note If you want the web browser to remember the password, select Remember Password before you click Log On.

Use the code of an application to connect to an AnalyticDB for MySQL cluster

Use the MySQL command line tool to connect to an AnalyticDB for MySQL cluster

Use the MySQL command-line tool to connect to AnalyticDB for MySQL

Use a MySQL client to connect to an AnalyticDB for MySQL cluster

Use a data visualization tool to connect to an AnalyticDB for MySQL cluster