Hi
I am still unable to connect to the mysql database
I have followed the instructions until being able to successfully install Terraform with this:
source scripts/setup.sh
After that I enter this
aws rds describe-db-instances --db-instance-identifier de-c1w2-rds --output text --query “DBInstances.Endpoint.Address”
After that I enter this and nothing comes up
mysql de-c1w2-rds.cz0yaeyom0yk.us-east-1.rds.amazonaws.com --user=admin --password=adminpwrd --port=3306
And i get this error:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
Please help!
Hello @ajitgarlapati,
it should start with mysql --host=de-c1w2…com --user=admin --password=adminpwrd --port=3306
Could you try adding --host and see if it fixes. Thank you
1 Like
Dear @Georgios
Yes I can solve my problem. Thank you very much for your support
1 Like
HI all,
I get the same error I followed all instructions and this is the issue. Please help. Says access denied. I verified that the db status is accessible. What else should I do?
coder@2192cf1e9dd2:~/project$ mysql --host=de-c1w2-rds.ctkaio0mi7o5.us-east-1.rds.amazonaws.com --user=admin --password=adminpwd --port=3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user ‘admin’@‘ec2-50-16-135-185.compute-1.amazonaws.com’ (using password: YES)
Hi Jessica, Please help. I am getting the error as access denied while trying to connect to eh rds. Where exactly to find this cloud9 environment setting that you gave the snippedt? Here is the error:
coder@2192cf1e9dd2:~/project$ mysql --host=de-c1w2-rds.ctkaio0mi7o5.us-east-1.rds.amazonaws.com --user=admin --password=adminpwd --port=3306
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user ‘admin’@‘ec2-50-16-135-185.compute-1.amazonaws.com’ (using password: YES)
Hello @suma_deeplearn,
Sorry for the inconvenience, I am afraid Jessica-dlai has opted out from the Course a while ago. I could reproduce your issue, and I suggest skipping this part for now since you should be able to run the queries and complete the assignment in part 5 without any other issues. I will keep you updated once I have any info of resolving the error. Thank you
1 Like
Hello @suma_deeplearn
It looks like I made the same mistake, the password should be adminpwrd.
You’ve used adminpwd, the r is missing. After that it should work, thank you
Hi @gerogios . Thank you so much for correcting. I will try today.
1 Like
tried all suggestions in threads above, rebooting the aws instance a few times, no success:coder@3dddd88047cf:~/project$ aws rds describe-db-instances --db-instance-identifier de-c1w2-rds --output text --query “DBInstances.Endpoint.Address”
Invalid endpoint: https://rds..amazonaws.com
BUT had been successful getting through to 4.12 AWS Glue Job 24 hrs ago, so don’t know what happened. After 2 hours I guess AWS instance for lab gets cleared, but have always been successful getting back to the pipeline …
Hello @lancepham,
There might be an issue with the lab exceeded limit since you could connect a day ago. Please submit this form for a lab refresh, note it takes 2 business days (no weekends) to complete. Hope it helps
Thanks, Georgios, I just logged the trouble ticket per your instruction. hope be able to get back to lab work asap. Love the course(!)
Thanks Georgios again for the quick response. Hope I can get back in it again, keep the “flow” of learning goin before work takes me away again. You guys are doing great work -
1 Like
Thanks Georgios. After two days, I get the AWS instance back, finished the lab c1w2, got thru with jupyter output ending with the visual data ouputs from widget execution, and submitted, but keeps showing 0% completed. So I checked the saved file, outputs are there. I saved as another file name, still didn’t take the results. NOW i kicked out of AWS resource again.
Hello @hawraa.salami,
It seems @lancepham had his lab refreshed and could finish the lab but didn’t pass the grader. Now his issue continues, should he submit the form again. Thanks
Thank you @Georgios for reaching out. I could see that the time limit budget has been exceeded, I already adjusted that. Please @lancepham try again the lab. And if you see that the grader still shows 0, please try to submit the assignment again. Please let us know if you’re still encountering the same issue.
