Unable to connect to Aurora MYSQL

Hi I have created the Aurora database with MySQL Compatibility. Given public access as this is for the current dev/sample environment. Did not create any VPC, but it uses the default one, for which I have checked the subnets if it has route table to internet gateway and if it is allowing the security group and Network ACL to 0.0.0.0/0 and Mysql port. I dont have firewall blocking the port 3306. It is not serverless as well. I tried to ping and got request timeout from my laptop. Please help. Thanks.

Ping request gives me below error

Request timed out. 

Connecting via mysql command gives me below error:

ERROR 1045 (28000): Access denied for user 'admin'@'x.x.x.x' (using password: YES) 
Add Comment
1 Answer(s)

Edit

It was confirmed to be a credentials issue, the OP reset their password which resolved the issue.

Original

The error you have is a credentials error, this proves connection between your host and Aurora is possible via the MySQL port.

The following should be checked to resolve the issue:

  • Check the username, if this was created with the Aurora Cluster check the console to ensure that it is spelt correctly.
  • Check the password you’re entering is correct, if this is the user you created with the Aurora cluster then reset the password from the console.

Regarding ping, the AWS knowledge center says

Amazon RDS doesn’t accept internet control message protocol (ICMP) traffic, including ping.

Below is more information about resolving connectivity issues from the knowledge center.

Answered on July 16, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.