I have two instances running in digital ocean.
Instance #1:
Running NodeJS MySQL grunt for web application.
'connection': {
'host': '`ip-address-for-instance-2`',
'user': 'root',
'password': '`password`'
},
Instance #2:
Running phpmyadmin by ‘instance-2-ip/phpmyadmin’
I had edit my.cnf bind address with my instance’s 2 IP address.
bind-address=`ip-address`
When I grunt my web application:
Error: connect ETIMEDOUT
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi @longsookeat,
Could you confirm if MySQL is installed on instance-2 and you only have Node js web app on instance-1?
Feel free to check the below tutorial which can guide you with allowing remote access to the MySQL database.
https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
Regards, Rajkishore