ApsaraDB RDS:Connect to an RDS MySQL instance by CLI or client

Connect with the CLI

1. Log on to the server that you will use to connect to the RDS instance, such as an ECS instance or a local server.

   Note

   For instructions on how to log on to an ECS instance, see the Connect to an ECS instance section in ECS Quick Start.

2. Run the following command to connect:

   mysql -h<endpoint> -P<port> -u<username> -p

   Note

   • Enter the password after you run the command.

   • The uppercase letter P specifies the port, and the lowercase letter p specifies the password prompt.

   • Endpoint and port: The endpoint and port of the RDS instance.

     Scenario	Required endpoint	How to obtain
     You meet the conditions for an internal network connection.	Internal endpoint	Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID. Click View Details to view the RDS instance address and port number. In the Basic Information section, next to Network Type, click View Connection Details. Note The public endpoint is displayed only after you click Apply for Public Endpoint. For an RDS Cluster Edition instance, you can modify the primary node endpoint in the Cluster Read/Write Connection section and the secondary node endpoint in the Cluster Read-only Connection section.
     You are connecting from an ECS instance, but do not meet the conditions for an internal network connection.	Public endpoint
     You are connecting from a local device.

   • Username and password: Obtain them from the Accounts page of the RDS instance.

   Command example

   root@xxx            -> mysql -hrxxx.mysql.rds.aliyuncs.com -P3306 -uxxx -p
   Enter password:

   Successful connection

   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 51325
   Server version: 8.0.18 Source distribution

   Note

   If a connection error occurs, see Common connection errors.

Connect with MySQL Workbench

You can also use other general-purpose MySQL clients. The following steps use MySQL Workbench 8.0.29 as an example.

1. Install MySQL Workbench.

2. Open MySQL Workbench and choose Database > Connect to Database.

3. Enter the connection information and click OK.

   From the Connection Method drop-down list, select Standard (TCP/IP).

   • Hostname and Port: The endpoint and port of the RDS instance.

     Scenario	Required endpoint	How to obtain
     You meet the conditions for an internal network connection.	Internal endpoint	Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the instance ID. Click View Details to view the RDS instance address and port number. In the Basic Information section, next to Network Type, click View Connection Details. Note The public endpoint is displayed only after you click Apply for Public Endpoint. For an RDS Cluster Edition instance, you can modify the primary node endpoint in the Cluster Read/Write Connection section and the secondary node endpoint in the Cluster Read-only Connection section.
     You are connecting from an ECS instance, but do not meet the conditions for an internal network connection.	Public endpoint
     You are connecting from a local device.

   • Username and Password: Obtain them from the Accounts page of the RDS instance.

Connect with Navicat

1. Start the Navicat client.

2. In the upper-left corner, click Connection and select your database type.

   Note

   If you use an earlier version of Navicat and the Alibaba Cloud menu is not available, you can directly select a database type, such as MySQL or PostgreSQL.

   In the Navicat toolbar, click Connection, select Alibaba Cloud from the drop-down menu, and then select the target database type from the submenu, such as Alibaba Cloud ApsaraDB for RDS (MySQL)..., Alibaba Cloud ApsaraDB for RDS (PostgreSQL)..., or Alibaba Cloud ApsaraDB for RDS (SQL Server)....

3. Enter the connection information for the RDS instance. The following table describes the parameters.

   Parameter	Description
   Connection Name	A custom name for the connection.
   Host	The internal endpoint or public endpoint of the RDS instance. Use the internal endpoint if your client is on an ECS instance in the same account, region, and VPC as the RDS instance. In other cases, use the public endpoint.
   Port	The internal port or public port of the RDS instance. For example, the default port for MySQL is 3306.
   User Name	The username for the account that accesses the RDS instance. You can find this on the instance's Accounts page.
   Password	The password for the specified username.

4. Click OK.

   Note

   If enhanced whitelist mode is enabled and you want to connect to the instance over the internet, add the public IP address of your client to the classic network group.

   After successfully connecting with a client such as Navicat, if you see databases such as busudab, information_schema, and mysql in the connection tree, the connection is successful.