Connection to MYSQL Server

Course Q&A Data Engineering Introduction to Data Engineering
1

Hi All,
I got a weird error. I am in the stage of connecting to the RDS MYSQL Database in the lab exercise in week 2.
At first, I successfully connected to the database but I suddenly closed the terminal. Then, I opened another Terminal but When I typed the connection Comand I got
mysql --host=de-c1w2-rds.cbkikws20ayk.us-east-1.rds.amazonaws.com --user=admin --password= adminpwrd --port=3306
ERROR 1045 (28000): Access denied for user ‘admin’@‘10.2.0.45’ (using password: NO)
now I ping the RDS database but after telling me some info, it didn’t let me to further do anything.

ping de-c1w2-rds.cbkikws20ayk.us-east-1.rds.amazonaws.com
PING de-c1w2-rds.cbkikws20ayk.us-east-1.rds.amazonaws.com (10.2.0.109) 56(84) bytes of data.

sudo service mysql restart

I would be grateful if you could help me figure this out.
Thanks,
Hossein

2

Hello @hossein_rahmani
There is a space between --password= and adminpwrd in your command, and I guess the problem is stemming from this space. Please, try again and omit it before running the command.