How Can I Obtain the IP Address of an Application?
Scenario
EIPs obtained through tools are inaccurate. Therefore, applications still cannot be connected to RDS DB instances even though you have added IP addresses to a whitelist. This section describes how to obtain a local IP address.
Procedure
- Add IP addresses or IP address ranges that are allowed to access DB instances to the RDS whitelist.
- Use the MySQL client to connect to an RDS for MySQL DB instance.
mysql -h host_name -P port -u username -p
Enter the password of the database account if the following information is displayed:
Enter password:
For example, if you run the following command as user root to connect to a DB instance:
mysql -h 192.168.0.1 -P 3306 -u root -p
Enter password:
- Query process information.
show processlist
Figure 1 shows the query result. The outbound IP address is the host IP address in the "show processlist" row of the Info field.
- View historical connection sources in audit logs if you have enabled SQL audit.
If this function is disabled, historical records cannot be viewed.
Database Connection FAQs
- What Should I Do If I Can't Connect to My RDS DB Instance?
- Can an External Server Access the RDS Database?
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- Why Can't I Ping My EIP After It Is Bound to a DB Instance?
- How Can I Obtain the IP Address of an Application?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
- Will My Access Be Restricted by Bandwidth When I Connect to My Instance from an ECS over a Private Network?
- Does RDS Support SSL Connections?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password?
- Will I Be Logged Out If the Connection to RDS for SQL Server Instances Times Out?
- How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
- What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
- How Do I View All IP Addresses Connected to a Database?
- Can I Access Standby RDS DB Instances?
- How Do I Check the Connections to an RDS for MySQL Instance?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore