- Newest
- Most votes
- Most comments
Hello.
When I try to connect to the cluster using the end point for the writer, my connections time out. If I use an AWS tool like 'Query Editor', I get an error that looks like an authentication failure "....Please check your user name, password, and database name..." AWS can certainly "see" my database. I do have Data API enabled for it.
Are you trying to connect from a local environment using something like Workbench?
In that case, I think you need to enable public access.
https://repost.aws/knowledge-center/aurora-mysql-connect-outside-vpc
By the way, public access is not recommended for security reasons, so I recommend using port forwarding using Session Manager, which is introduced in the document below.
https://aws.amazon.com/jp/blogs/mt/use-port-forwarding-in-aws-systems-manager-session-manager-to-connect-to-remote-hosts/
Also, why not try changing the RDS user password once?
If you can connect after changing the password, the password specified in the query editor may be incorrect.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Modifying.html#Aurora.Modifying.Password
Relevant content
- Accepted Answerasked 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Riku, thanks for your thoughtful answers.
Changing the Aurora master password to match the password of the primary db instance did allow me to connect through Query Editor.
However, I still can't connect from outside my local environment, even though Aurora's primary instance is in the same network environment as my provisioned instances. The VPC and its subnets are all public and the ACLs and SGs allow all traffic both ways. I can connect to the provisioned instance from my local environment.
My larger goal is to connect to my Aurora cluster through an AppSync GraphQl API. I have had no luck with that either.