Run MySQL query ERROR: connect ETIMEDOUT

Questions
21

Let me jump here with one observation, which might help

On the screenshot where you tried the same query using PHPMyAdmin, you have executed the following query

'SELECT id FROM contact WHERE 'id' LIKE '[email protected]''

In n8n, you are using this

'SELECT id FROM contact WHERE id LIKE '[email protected]''

I don’t know if this can make a difference but putting “id” in the single quotes after WHERE clause might help

Regards,
Igor

1 Like
22

I tested, but it is the same

I think MySQL 8 syntax support more for non-table like Postgres. And it need more procedure in its. I will try to change to Postgres or load mysql by javascript function…

23

Well, I create a mysql 8 from docker and test again
When I try to test at first, it failed again

I realize that when I update credentials, I must delete node and recreate it again
When I recreate node and test again, it is successfully now

24

First great to hear that it works.

But very strange. Deleting and recreating should normally not be necessary. I wonder what is happening there. The only thing something like that should make a difference is if the workflow is already active and the credentials get changed. In this case, activating and deactivating should be enough.

1 Like