Remote mysql database connection failing using mysql navicate

0

l have created a test mysql database but l am failing to connect using mysql navicat. l am getting this error.

2002 - Can't connect to server on 'nts-test.cluster-ch0imiicmn7r.us-east-1.rds.amazonaws.com' (60)

1 Answer
0

1.** Security Group Issues:** By default, RDS instances are secure and don't allow connections from anywhere. You need to configure your security group to allow inbound connections on port 3306 (the default MySQL port) from the specific IP address or IP range where MySQL Navigator is running.

  1. Incorrect Credentials: Double-check your username, password, and database name
  2. RDS Instance Status: Make sure your RDS instance is in the "available" state. You can check the status in the AWS Management Console.

Here are some resources to help you troubleshoot further:

Troubleshooting for Amazon RDS: https://repost.aws/knowledge-center/rds-cannot-connect

profile picture
EXPERT
GK
answered 24 days ago
  • Thanks .. l think its the security group because l used the default one. Now checking how to change the rules

  • Okay, Please do comment if you still have issues

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions