"error": "Could not connect to MySQL:\nError: Handshake inactivity timeout"

1,605 views
Skip to first unread message

reza primasatya

unread,
Aug 27, 2015, 2:26:55 AM8/27/15
to sails.js
Hi,

I got error ( "error": "Could not connect to MySQL:\nError: Handshake inactivity timeout" ).

Sails apps server(192.168.10.10)  Database Mysql(192.168.10.11).

Config:
someMysqlServer: {
    adapter: 'sails-mysql',
    host: '192.168.100.4',
    user: 'root',
    port: 3306,
    password: 'xxx',
    database: 'yyy'
  },

If SailsApps and DB in the same machine, it works well  but if different machine I got error.

Please need help?

Thanks


Ambroise Dhenain

unread,
Aug 27, 2015, 3:55:23 PM8/27/15
to reza primasatya, sails.js
Why do you configure a different IP in the config? Shouldn't it be 192.168.10.11 instead of 192.168.100.4?
--
Cordialement,

M. Ambroise Dhenain.

reza primasatya

unread,
Aug 27, 2015, 8:09:37 PM8/27/15
to Ambroise Dhenain, sails.js

Sory typo ... correct IP in config is 192.168.10.11

I was change config in mysql about limitation..but still got same problem

Reply all
Reply to author
Forward
0 new messages