MySQL Forums
Forum List  »  Newbie

Help me connect to my database in AWS
Posted by: Evgenie Tivaniuk
Date: March 31, 2023 08:08AM

Hello,
I am trying to learn about using AWS. I created a MySQL database with an instance on AWS, and now trying to connect to it. But, I get error messages.

I can't find a way to post images here (is there one?), so will try to explain with words and put values I think are important.

On AWS:
Database name: "mysqltest"
Port: 3306
Endpoint: mysqltest.**********.eu-west-2.rds.amazonaws.com
VPC security groups: default (sg-0462ed684c759af3c)
Publicly accessible: Yes
Master username: evgeniet
Master password: ***
*******

In mySQL (Edit or Create connection):
Hostname: mysqltest.**********.eu-west-2.rds.amazonaws.com (as Endpoint)
Port: 3306
Username: evgeniet (should it be defined anywhere else, except Master username, or anywhere in MySQL?)

Password: was trying the same as in AWS, or without onw, so it will ask later, but it didn't help.

I didn't touch "SSL" and "Advanced" tabs.

When trying to "Test ConnectiI get message that I can't connect to ***localhost*** with given user.
When just trying to connect, I get a long message with 4 for possible errors:

1) Check that mySQL is running on given address (as in hostname)
2) Check that mySQL is reachable on given port
3) Check that given user has rights to connect to given address
4) Make sure that password is correct.


Please help.
I am good with SQL, but never worked with cloud server, now want to learn using it.

Thank you in advance,
Evgenie

Options: ReplyQuote


Subject
Written By
Posted
Help me connect to my database in AWS
March 31, 2023 08:08AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.