What Should I Do If an ECS Cannot Connect to a GaussDB(for MySQL) DB Instance?
Perform the following steps to identify the problem:
- Check whether the ECS and GaussDB(for MySQL) DB instance are located in the same VPC.
- If they are in the same VPC, go to 2.
- If they are in different VPCs, create an ECS in the VPC where the DB instance is located.
- Check whether a security group has been created for the ECS.
- If a security group has been created, check whether its configuration rules are suitable.
For operation details, see the security group description in "Creating a DB Instance" in the GaussDB(for MySQL) Getting Started and then go to 3.
- If no security group has been created, go to the VPC console from the ECS details page and create a security group.
- If a security group has been created, check whether its configuration rules are suitable.
- Check whether the ECS can connect to the DB instance over the instance port.
The default port of the DB instance is 3306.
telnet <IP address> {Port number}- If the ECS can connect to the DB instance port, the network between the ECS and the DB instance is normal.
- If the ECS cannot connect to the DB instance port, contact technical support.
- If you originally use the common connection and later change it to the SSL connection for enhanced security, you should use the SSL login. Otherwise, the following error will be reported:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2026 (HY000): SSL connection error: protocol version mismatch
Check whether the connection method is a common connection or an SSL connection.
If you use the SSL connection, check whether SSL has been enabled.
Did this article solve your problem?
Thank you for your score!Your feedback would help us improve the website.