Hi Adnan, Thank you so much with your wonderful article. I did exactly same as it till doing offline test. I got an issue which it can not connect to the Aurora DB. The things I have tried is :
check the error from Sequelize. I got an SequelizeConnectionRefusedError with "ECONNREFUSED"
deploy to aws. ( same issue can not connec to db )
What I missed during the process that cause the issue?
In the secrets.json file, What should be changed according to my RDS configuration ( especially DB_HOST and DB_NAME)
Had the same exact issue and as someone with a mac with no mysql installed this was the solution for me. Remember a local instance of mysql needs to still be available.
Install mysql locally
brew install mysql
Start MySQL
mysql.server start OR service mysqld start
Make change to user auth
Per stack overflow need to edit password auth
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
mysql -u root -p
"password"
Make sure to change the db.js DB_PASSWORD
db.js
"DB_PASSWORD": "password"
and voila it worked for me
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Hi Adnan, Thank you so much with your wonderful article. I did exactly same as it till doing offline test. I got an issue which it can not connect to the Aurora DB. The things I have tried is :
What I missed during the process that cause the issue?
In the secrets.json file, What should be changed according to my RDS configuration ( especially DB_HOST and DB_NAME)
Had the same exact issue and as someone with a mac with no mysql installed this was the solution for me. Remember a local instance of mysql needs to still be available.
Install mysql locally
brew install mysql
Start MySQL
mysql.server start OR service mysqld start
Make change to user auth
Per stack overflow need to edit password auth
mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
mysql -u root -p
"password"
Make sure to change the db.js DB_PASSWORD
db.js
"DB_PASSWORD": "password"
and voila it worked for me