Remote SQL server is not working

October 26, 2017 151 views
MySQL Ubuntu

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

Be the first one to answer this question.