Week 2: Lab: Mysql

Hi all please help - Unable to connect to mysql. Gives an error that password cannot be used in terminal. Here is the complete error message.Everyone is talking about cloud 9 environment where are the steps maintained?
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)
coder@2192cf1e9dd2:~/project$

I think that message just means that the password as given is incorrect.

MySQL will warn if you have the password in cleartext in the command because on a Unix system, other users may be able to see the command line when listing processes.

1 Like

Hello @hawraa.salami,

It seems I have the same error from the mysql command like @suma_deeplearn, I could finish the assignment without connecting to the database and get full marks. Perhaps you could check it, thanks

Thank you @Georgios!

@suma_deeplearn The password should be adminpwrd.

You’ve used adminpwd, the r is missing.

1 Like

Thanks for the quick reply it seems you are right. It helped

2 Likes