HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Not able to login on MySQL in AWS RDS using root

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
loginmysqlusingawsrootrdsnotable

Problem

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

$ mysql -h xxx.xyz.ap-southeast-1.rds.amazonaws.com -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

Solution

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.

Context

StackExchange Database Administrators Q#52278, answer score: 9

Revisions (0)

No revisions yet.