ApsaraDB RDS:Use a client or the CLI to connect to an ApsaraDB RDS for MySQL instance

Connect using the CLI

Install MySQL before connecting:

• CentOS: sudo yum install mysql

• Ubuntu: sudo apt-get update then sudo apt install mysql-server

Steps:

1. Log in to your server (an ECS instance or an on-premises device).

   For ECS login instructions, see the Connect to an instance section in Create and manage an ECS instance by using the ECS console (express version).

2. Run the connection command:

   -P (uppercase) is the port. -p (lowercase) is the password. The default MySQL port is 3306. Get the username and password from the Accounts page in the instance details.

   mysql -h<Endpoint> -P<Port> -u<Username> -p<Password>

   You can omit the password flag and enter it when prompted.

3. A successful connection displays the MySQL prompt: Example command: If the connection fails, check the following: For error-specific solutions, see Troubleshooting.

   • Is your client IP address added to the RDS IP address whitelist? Run curl ipinfo.io/ip to get your public IP address, then add it to the whitelist.

   • Are you using the internal endpoint when the ECS and RDS instances don't meet the internal-network conditions? Switch to the public endpoint.

   • Is the endpoint format correct? Valid endpoints follow the format rm-xxxxxx.mysql.rds.aliyuncs.com.

   • Are the username and password correct? Get them from the Accounts page in the instance details.

   

   

Connect using MySQL Workbench

This example uses MySQL Workbench 8.0.29. Other MySQL clients follow a similar process.

1. Download and install MySQL Workbench.

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

3. Enter the connection details and click OK.

   The public endpoint appears only after you click Apply for Public Endpoint. For RDS clusters, modify the read/write endpoint in the Cluster Read/Write Connection section and the read-only endpoint in the Cluster Read-only Connection section.

   Parameter	Description	Example value
   Hostname	The internal or public endpoint of the RDS instance. See Choose your connection type.	rm-xxxxxx.mysql.rds.aliyuncs.com
   Port	The port number.	3306
   Username	The account username. Get it from the Accounts page in the instance details.	alice
   Password	The account password.	—

   

Connect using Navicat

1. Open Navicat and click Connection in the toolbar. Select the database type to connect to.

   If your Navicat client is outdated, Alibaba Cloud may not appear in the list. Select MySQL or PostgreSQL instead.

   

2. Enter the connection details.

   Parameter	Description	Example value
   Connection Name	A name for this connection.	my-rds-prod
   Host	The internal or public endpoint of the RDS instance. Use the internal endpoint if the ECS and RDS instances meet internal-network conditions; otherwise use the public endpoint.	rm-xxxxxx.mysql.rds.aliyuncs.com
   Port	The port number.	3306
   User Name	The account username.	alice
   Password	The account password.	—

   

3. Click OK.

   If enhanced whitelist mode is enabled and you're connecting over the Internet, add the public IP address of your device to the IP address whitelist of the classic network type.