Need to send data from iot2040 to mysql workbench which is installed on my laptop

Hello People,

I want to send data from IOT2040 to my MySQL Workbench which is installed on my Laptop.
I am getting an error which is as follows :

"Error: ER_HOST_NOT_PRIVILEGED: Host '192.168.200.1' is not allowed to connect to this MySQL server"

Here 192.168.200.1 is my IOT2040 Device IP Address.

I have attached the photo below.
Please help me resolve this issue.

This is down to your database setup (not a node-red or node issue).

The default configuration of mysql allows connections only from the 'root' user when coming from 'localhost' and not other IP addresses. There are many answers on the web.

But how can this be solved? Can you help me out for this?

Did you click the link? Did you read the solutions? Did you try any of them?

Yes i did click the link.
Read the solution.
Applied some.
Works and shows connection successful.
And then after ingesting from NodeRED into Mysql node....NODERED CRASHES.

What does the stack trace/logs show?

Have you looked at the existing issues on the GitHub repository - it might already be raised as an issue. If not, raise an issue and describe what you are doing and show the stack trace from the console.

"Issues · node-red/node-red-nodes · GitHub" Issues · node-red/node-red-nodes · GitHub

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.