I recently created an MySQL instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance from the MySQL command line. I will brief you the details.
1) I want to move/migrate my MySQL database from local machine to this RDS instance.
I did a bit of searching in stackoverflow & found few links.
2) I have an RDS instance with the following details.
Endpoint: end.awsabc.com My RDS db master username: iammaster. I don't know the password. RDS db name: rdsdb local machine db name: localdb name of SQLdump file of localdb: localdump.sql
3) These are the commands that I used in command prompt:
mysql -h end.awsabc.com -u iammaster-p rdsdb< D:\localdump.sql ERROR 2003: Cannot connect to MySQL server on abcdtrash.rds.com
Then I tried another method: This is the command I typed in the command prompt:
C:\wamp\bin\mysql\mysql5.6.17\bin>mysqldump -u root localdb| mysql --host=end.awsabc.com --user=iammaster rdsdb Error: Access denied.
Is this because I don't have a password?? Can anyone tell me how to accomplish the task?