Connect to RDS eb2 by tableplus?

Admin 1
Viewed 2333

I have table plus app and I create eb then deploy my project then connect to database and all thing is good and cool!

I need to connect to database(MYSQL) to import some data to the AWS database so I do these steps:

  1. open new workspace in table plus
  2. take endpoint and username of database and the password and the name of database like so:

enter image description here

  1. press Test button and after wait some times I got this error:

enter image description here

I change the port to also 5432 and got same first error

  1. I change the port to 3306 and got this error:

enter image description here

where is the problem ?

amazon-elastic-beanstalk amazon-web-services
3 Answers

Ok the way i did it was by following this video: https://www.youtube.com/watch?v=saX75fTwh0M&ab_channel=AdobeinaMinute

In short you need to get the details of your instance and set up an ssh connection to it using its hostname (ie that of the instance not the db), your ec2 username (usually ec2-user) and your pem file. Then you get the connection details for the db and enter them. See the screenshot.

enter image description here

user_28678940

I think that your problem is that the configuration you created is set to a Redshift connection. It expects some network communications that are different from a MySQL connection.

Can you try to create a MySQL connection instead?

user_53376490

I had the same issue but my problem was with the security rules in aws. perhaps, this may help.

  • Navigate to the console
  • edit inbound rules of your rds instance
  • add a new security rule
  • where: type: 'all traffic', source: anywhere This video gives a google explanation: aws rds setup
user_46177220
Related