# Need to send data from iot2040 to mysql workbench which is installed on my laptop
**URL:** https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572
**Category:** General
**Created:** [13 May 2021 07:03 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572 "2021-05-13T07:03:37Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Swapnil](https://discourse.nodered.org/u/Swapnil)
#### Post date: [13 May 2021 07:03 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/1 "2021-05-13T07:03:37Z")
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.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2021 07:10 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/2 "2021-05-13T07:10:10Z")
> [@Swapnil](#):
>
> is not allowed to connect to this MySQL server
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](https://www.google.com/search?q=is+not+allowed+to+connect+to+this+MySQL+server).
---
### Author:  [@Swapnil](https://discourse.nodered.org/u/Swapnil)
#### Post date: [13 May 2021 08:56 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/3 "2021-05-13T08:56:11Z")
But how can this be solved? Can you help me out for this?
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2021 09:00 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/4 "2021-05-13T09:00:24Z")
Did you click the link? Did you read the solutions? Did you try any of them?
---
### Author:  [@Swapnil](https://discourse.nodered.org/u/Swapnil)
#### Post date: [13 May 2021 12:19 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/5 "2021-05-13T12:19:31Z")
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.
---
### Author:  [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [13 May 2021 12:22 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/6 "2021-05-13T12:22:38Z")
> [@Swapnil](#):
>
> 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](https://github.com/node-red/node-red-nodes/issues)
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [12 July 2021 12:23 UTC](https://discourse.nodered.org/t/need-to-send-data-from-iot2040-to-mysql-workbench-which-is-installed-on-my-laptop/45572/7 "2021-07-12T12:23:01Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.