After doing a lot of mysql locally i am trying something from one to another server now
It works but after about 8 seconds i get etimedout
When i trigger the node again i get a correct output then 8 sec later again a etimedout
Also start node-red in a terminal and see if there are any other errors or warnings there. What version of node-red, nodjs and the sql node are you using? In fact it might be worth starting node-red in a terminal and copying the log in the terminal up to the point of failure and posting it here.
While searching thru the forum i found out that i did not include the error message
"Error: connect ECONNREFUSED 184.108.40.206:3306"
maybe this helps or someone else in the future... i continue to find a fix
it was a new install, no idea who or what
only saw somewhere that it is not advised to turn it on
For mysqld external locking is controlled by the value of the skip_external_locking system variable. When this variable is enabled, external locking is disabled, and vice versa. External locking is disabled by default.