This makes no sense to me. Of course I added the droplet to my managed cluster as a trusted source. I completely disabled the UFW firewall on the droplet, and am still getting the same error.

I never had a problem connecting to my MySQL droplet, even though I never opened incoming port 3306 on the web droplet’s firewall. So, I’m not sure why I’d have to open incoming port 25060 on the web droplet to connect to the MySQL cluster. I allowed all outgoing traffic by default, and like I said still getting the same error even with UFW completely disabled.

I would suggest testing the connection from your droplet to the managed cluster using telnet to make sure that the droplet is actually able to communicate with the cluster:

telnet your_managed_cluster 25060

The the Handshake inactivity timeout error means that the default timeout was exceeded which usually is due to something interfering with the connection such as a firewall or some configuration problem. This is why I mentioned that you need to make sure that the custom port is open on your droplet, and I was referring to outgoing traffic of course.

I tried this at my end:

• I created a new managed cluster and a new droplet

• I allowed the traffic from the droplet to the cluster and I allowed the droplet on the cluster as well

• I used ALTER to adjust the default user

• Then I installed node test the connection and I created a simple test.js app:

My package.json:

{
  "name": "node-mysql",
  "version": "0.0.1",
  "dependencies": {
    "express": "^4.10.6",
    "mysql": "^2.5.4"
  }
}

My test.js file:

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'my_cluster.db.ondigitalocean.com',
  user     : 'doadmin',
  password : 'my_password',
  database : 'defaultdb',
  port     : '25060'
});

connection.connect(function(err){
if(!err) {
    console.log("The connection was successful!");    
} else {
    console.log("Error connecting to database..");    
}
});

connection.query('SELECT * from test', function(err, rows, fields) {
  if (!err)
    console.log('Result: ', rows);
  else
    console.log('Error while performing Query.');
});

connection.end();

• I created a test table with 1 entry only.

It all worked like a charm:

# node test.js 
The connection was successful!
Result:  [ RowDataPacket { test: 'It works!' } ]

Hope that this helps!
Regards,
Bobby

Tried this, still unable to connect due to this Node error:

2019-09-06T20:30:10.007394293Z app[web.1]: { Error: Handshake inactivity timeout
2019-09-06T20:30:10.007419844Z app[web.1]:     at Handshake.<anonymous> (/app/node_modules/mysql/lib/protocol/Protocol.js:160:17)
2019-09-06T20:30:10.007445275Z app[web.1]:     at Handshake.emit (events.js:197:13)
2019-09-06T20:30:10.007453335Z app[web.1]:     at Handshake._onTimeout (/app/node_modules/mysql/lib/protocol/sequences/Sequence.js:124:8)
2019-09-06T20:30:10.007460212Z app[web.1]:     at Timer._onTimeout (/app/node_modules/mysql/lib/protocol/Timer.js:32:23)
2019-09-06T20:30:10.007466844Z app[web.1]:     at listOnTimeout (timers.js:327:15)
2019-09-06T20:30:10.007484431Z app[web.1]:     at processTimers (timers.js:271:5)
2019-09-06T20:30:10.007492423Z app[web.1]:     --------------------
2019-09-06T20:30:10.007522501Z app[web.1]:     at Protocol._enqueue (/app/node_modules/mysql/lib/protocol/Protocol.js:144:48)
2019-09-06T20:30:10.007529061Z app[web.1]:     at Protocol.handshake (/app/node_modules/mysql/lib/protocol/Protocol.js:51:23)
2019-09-06T20:30:10.007535556Z app[web.1]:     at PoolConnection.connect (/app/node_modules/mysql/lib/Connection.js:119:18)
2019-09-06T20:30:10.007542081Z app[web.1]:     at Pool.getConnection (/app/node_modules/mysql/lib/Pool.js:48:16)
2019-09-06T20:30:10.007551525Z app[web.1]:     at Pool.query (/app/node_modules/mysql/lib/Pool.js:202:8)
2019-09-06T20:30:10.007557870Z app[web.1]:     at /app/model/database.js:17:8
2019-09-06T20:30:10.007584365Z app[web.1]:     at new Promise (<anonymous>)
2019-09-06T20:30:10.007591333Z app[web.1]:     at Object.exports.query (/app/model/database.js:15:9)
2019-09-06T20:30:10.007597417Z app[web.1]:     at Object.exports.get (/app/model/reminder.js:33:25)
2019-09-06T20:30:10.007603221Z app[web.1]:     at sendReminders (/app/reminder.js:16:34)
2019-09-06T20:30:10.007609780Z app[web.1]:   code: 'PROTOCOL_SEQUENCE_TIMEOUT',
2019-09-06T20:30:10.007615978Z app[web.1]:   fatal: true,
2019-09-06T20:30:10.007622201Z app[web.1]:   timeout: 10000 }