Not able to login on MySQL in AWS RDS using root

Posted on

Question :

I am trying to connect my MySQL RDS from EC2. Under security groups I have made sure permissions are in place.

$ mysql -h -P 3306 -p
Enter password:

I am sure password is correct; because i reset it using AWS console. I am getting following error:

 Access denied for user 'root'@'ip-xx-xxx-xxx-xxx.ap-southeast-1.compute.internal' (using password: YES)

Looks like

Answer :

I am 99% sure that Amazon RDS does not give you a ‘root’ access. i.e. You can’t create a user as ‘root’@’localhost’ or ‘root’@”.

Can you confirm user you have used while launching Amazon RDS instance? and make sure that Password matches with user created.

It looks like there is a bug in AWS console. Most likely you’ve provided a password with restricted characters for the master user. In this case, AWS console doesn’t prevent it, but you will never manage to connect to the database, even you’ll change a password (BTW here AWS console will not allow you to insert restricted characters). The only way to cope with this issue is the redefinition of a new RDS instance/cluster (Definitely you can try to resolve it with the AWS support team)

P.S. Even though it was reported many years ago, the bug still exists there))

Leave a Reply

Your email address will not be published. Required fields are marked *