patternsqlMinor
Not able to login on MySQL in AWS RDS using root
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.
I am sure password is correct; because i reset it using AWS console. I am getting following error:
Looks like
$ 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.
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.