# ER\_HOST\_NOT\_PRIVILEGED

**URL:** <https://discourse.nodered.org/t/er-host-not-privileged/5359>\
**Category:** General\
**Created:** [30 November 2018 16:42 UTC](https://discourse.nodered.org/t/er-host-not-privileged/5359 "2018-11-30T16:42:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zayas](https://avatars.discourse-cdn.com/v4/letter/z/d2c977/32.png) [@zayas](https://discourse.nodered.org/u/zayas)\
**Post date:** [30 November 2018 16:42 UTC](https://discourse.nodered.org/t/er-host-not-privileged/5359/1 "2018-11-30T16:42:53Z")

</div>

Hello, I am trying to communicate the node network with mysql and I get the following error: ER\_HOST\_NOT\_PRIVILEGED, why is it? In MySQL I have the users with all the privileges and I use it through the MySQL server, but it seems that the IP to which I want to connect, is "closed" and does not let me access it. In the MySQL website they say that it is because the user has to be configured with all the privileges, but I use this function to change the configuration and I still get the same error. The MySQL of the node network is well configured ...

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [30 November 2018 17:01 UTC](https://discourse.nodered.org/t/er-host-not-privileged/5359/2 "2018-11-30T17:01:07Z")

</div>

Hi, sorry, but that is 100% a mysql configuration issue. Not much we can advise from the Node-RED side.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [30 November 2018 17:33 UTC](https://discourse.nodered.org/t/er-host-not-privileged/5359/3 "2018-11-30T17:33:23Z")

</div>

Check with a command line mysql client (or other client s/w) running on the same machine as node-red that you are able to access the server. Once that works then it should be ok in node red.