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.
https://stackoverflow.com/questions/11731714/how-do-i-import-a-local-mysql-db-to-rds-db-instance
https://stackoverflow.com/questions/18565634/how-to-import-mysql-dump-into-amazon-rds?rq=1
http://trisummittechnologies.com/importing-mysql-data-into-rds/
https://stackoverflow.com/questions/11769605/php-site-not-connecting-to-mysql-on-amazon-rds
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?