# How to connect DB node to a local server?

**URL:** <https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648>\
**Category:** General\
**Tags:** database, function-node\
**Created:** [19 August 2022 07:48 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648 "2022-08-19T07:48:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mykerinos1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mykerinos1/32/46877_2.png) [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Post date:** [19 August 2022 07:48 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648/1 "2022-08-19T07:48:52Z")

</div>

Hello. i moved my database on my local server sinology. I don't know how to set DB node. because nodered is on a raspberry and database is with an other ip. So if i set localhost it doesnt work. if i set server ip like http// 192.168.86.78 with port 3306 it doesnt work. what can i set ?  
thanks

---

<div class="post-metadata">

**Author:** ![simmani5](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/simmani5/32/57008_2.png) [@simmani5](https://discourse.nodered.org/u/simmani5)\
**Post date:** [19 August 2022 08:46 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648/2 "2022-08-19T08:46:16Z")

</div>

if you use MySQL db then there is no problem.  
mysql command grant it will help you ..

```auto
mysql> grant all on *.* to yourDbID identified by 'yourDbPasswd';
mysql> flush privileges;

```

---

<div class="post-metadata">

**Author:** ![mykerinos1](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mykerinos1/32/46877_2.png) [@mykerinos1](https://discourse.nodered.org/u/mykerinos1)\
**Post date:** [19 August 2022 12:00 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648/3 "2022-08-19T12:00:59Z")

</div>

it was something like that. i had to accord privilege to my raspberry .  
Thanks for help

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [18 October 2022 12:01 UTC](https://discourse.nodered.org/t/how-to-connect-db-node-to-a-local-server/66648/4 "2022-10-18T12:01:39Z")

</div>

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