I installed node-red on a laptop running Ubuntu 18.04. It was installed from the Snap Store so I am not relly sure how to change settings.js. The flow goes like this: node-red-node-openweathermap 0.2.1 access OpenWeatherMAPI API | Function Node c…

[image] rewatkins114: Error: ER_ACCESS_DENIED_ERROR: Access denied for user ''@'localhost' (using password: NO) Are you sure you have mysql configured correctly to begin with, as per (for example) ... NODE-RED MYSQL NODE connection refused

If you are using the snap it runs by default in restricted mode so may not have access to anything outside of its container, so depending on how mongo is configured they may not be able to talk. If Node-RED is the only snap I would recommend you either run it either in "classic" mode which will give…

Honestly, I am unhappy running it under Snap. As far I can tell they have compressed somewhere that I really can't get to. In the past I have used node red on a Rasbrry Pi2 or 3. I wanted it on the laptopp because it has 1 TB storage andthe pi 16 GBs. On the Pi I always ran a script. Prior to …

This is the connfiguration. [image] The insert query writes. There is new record every 10 minuutes (over 80 records sine last night). Below is the Select Query the Inject node: Select dt, tempF, humidity, dewPt, clouds from tblObs Where dt >= DATE_SUB(Now(), INTERVAL 2 DAY) Order By dt Th…

Hello Richard, As a newbie, pardon me for asking. Have you check command line access to the database using mysql from the same environment? Kind regards.

Today I completely reloaded the computer. Ubunto 18.04, Lamp Stack (with MariaDB),and Node-Red. The errors are gone. I have no idea but I am glad they did. Richard

Glad to hear that you are back on track. Thanks for closing the loop with your feedback. Helps us to remember one more resolution option during troubleshooting. Kind regards.

Node-red-node-mysql not behaving

General

Bobo 21 November 2019 07:56 2

Are you sure you have mysql configured correctly to begin with, as per (for example) ...NODE-RED MYSQL NODE connection refused

Topic		Replies	Views
Update broke MySQL, old versions of Node-red-nodes have been removed. Why and where are they? General	31	1389	7 September 2021
NODE-RED MYSQL NODE connection refused General	26	14801	16 February 2021
I have issue when i connect MSSQL with Node Red General node-red-dashboard	77	2300	24 May 2022
"Deploy failed: No response from server" when inserting into MySQL General	38	4291	18 June 2021
Read from mysql db Dashboard	54	17650	23 December 2018

Node-red-node-mysql not behaving

Related topics