# Modify the mysql Node properties via dashboard

**URL:** <https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231>\
**Category:** Dashboard\
**Tags:** database\
**Created:** [15 December 2021 10:41 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231 "2021-12-15T10:41:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rum1](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rum1](https://discourse.nodered.org/u/Rum1)\
**Post date:** [15 December 2021 10:41 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231/1 "2021-12-15T10:41:17Z")

</div>

Hello together,

is it possible to modify the properties of the mysql Node via text input (or something else) from the dashboard.

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/f/8f613f1e9c6b1b66adda1422a4b39b2890671d65.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/e/6ed642c1686fe193c7b3905d160445f381b22a2a.png)

Or does anyone know if it is possible to configure the properties of a Node via dashboard?

Thanks in advance.

Kind regards,  
Rum1

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [15 December 2021 10:53 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231/2 "2021-12-15T10:53:00Z")

</div>

If you look at the 'Help' tab for the node it says this:

> # mysql
> 
> Allows basic access to a MySQL database.
> 
> This node uses the **query** operation against the configured database. This does allow both INSERTS and DELETES. By its very nature it allows SQL injection... so _be careful out there..._
> 
> `msg.topic` must hold the _query_ for the database, and the result is returned in `msg.payload` .
> 
> `msg.payload` can contain an array of values to bind to the topic.
> 
> Typically the returned payload will be an array of the result rows. **Note** : these are of type _RowDataPacket_ , and not a completely standard object.
> 
> If nothing is found for the key then _null_ is returned,
> 
> The reconnect timeout in milliseconds can be changed by adding a line in **settings.js**

Since it doesn't say you can dynamically change them, then you can't.

---

<div class="post-metadata">

**Author:** ![Rum1](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rum1](https://discourse.nodered.org/u/Rum1)\
**Post date:** [15 December 2021 11:06 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231/3 "2021-12-15T11:06:14Z")

</div>

Thank you for the fast reply!  
I saw this but I was not sure if there is maybe another way to do it.

But now I know there is no other way, thank you. 🙂

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 December 2021 12:35 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231/4 "2021-12-15T12:35:06Z")

</div>

You have a few options...

1. Fork the node and add that functionality (or hire someone to do it)
  1. If it works well, you might consider a PR back to the main repo

2. Use env variables instead of hard coded values in the config node
3. see [here](https://nodered.org/docs/user-guide/environment-variables) for info
4. add multiple nodes and configs - each set for a different database & route messages from dashboard appropriately

NOTE: environment variables are only read when node-red starts. To set them via dashboard you would need some way of setting the OS env variables (where node-red runs) and restarting node-red - not simple but possible.

---

<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:** [14 January 2022 12:35 UTC](https://discourse.nodered.org/t/modify-the-mysql-node-properties-via-dashboard/55231/5 "2022-01-14T12:35:57Z")

</div>

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