RDS Mysql ERROR 1045 (28000): Access denied for user @IP (using password: YES)

Question

[This is not a duplicate question]

I have created a RDS MySQL instance with same Security Policy and under same VPC as my EC2 instance.

However when i am trying to access the Instance from EC2 machine i am getting error: ERROR 1045 (28000): Access denied for user 'User'@'IP' (using password: YES)

Not sure if i am missing Anything.

In MYSQL setup we can resolve this error with added Privileges for User on the IP.Not sure how can we resolve this since i am unable to access the Instance itself.

Anyone faced this issue before?.

I have followed the Document: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html#MySQL.Procedural.Importing.Create.RDS.Database

Answer 1

mysql -h dandy-dbamazonaws.com[...] -u root -p 

-h - put your endpoint
-u - username you set for your local mysql (root in my case). Don't confuse it with instance name
-p - after you hit 'enter' enter the password for your instance (the one you set up during instance creation)

hope it will work! that's how I resolved this issue

Answer 2

Maybe late but I had the same problem today.

1. Confirm the MasterUsername, with the AWS CLI running aws rds describe-db-instances or in the web console, showing the cluster details on the configuration tab.
2. Confirm the password, if you are using linux consoles (bash) some some characters may be problematic like # or !.
3. If you are using ssl connection you can't use --ssl-mode=DISABLED. You have to use --ssl-mode=VERIFY_CA (if you are connecting to endpoint) or --ssl-mode=VERIFY_IDENTITY (OR VERIFY_CA) if are connecting to server endpoint.