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
If you connect from the node red server machine using the msyql command line does it fail after a while in a similar way?
Also look in the mysql logs for any clues.
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.
My provider and friend checked all but cannot find a solution.
I can create a test account if you like so you can have a look at it to check if it is not NR related.
Is that an idea?
While searching thru the forum i found out that i did not include the error message
"Error: connect ECONNREFUSED 99.99.97.99: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.