# Is there any way to do dynamic configuration for mysql node in node-red?
**URL:** https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354
**Category:** General
**Created:** [28 February 2020 06:28 UTC](https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354 "2020-02-28T06:28:53Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Jignesh](https://discourse.nodered.org/u/Jignesh)
#### Post date: [28 February 2020 06:28 UTC](https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354/1 "2020-02-28T06:28:53Z")
I am using node-red-node-mysql node to connect with mySQL database. I want to set my database credential (i.e. server name, db name, uid and password) from global variables.
Is there any way to do it?
---
### Author:  [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [28 February 2020 10:01 UTC](https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354/2 "2020-02-28T10:01:25Z")
not at this point in time.
---
### Author:  [@unixneo](https://discourse.nodered.org/u/unixneo)
#### Post date: [28 February 2020 10:20 UTC](https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354/3 "2020-02-28T10:20:40Z")
You can do the "next best thing" and just put the params in a function node, save it as a custom flow (of whatever the correct word is for it, my bad if I got the exact word wrong again), and use it to pass the params to another MySQL function (where you have your custom MySQL logic).
FYI, I do not use the mysql plugin ( `node-red-node-mysql` ) and write all my MySQL code in a function node (it is really simple anyway, some basics below) because it works much better, at least for me. This is especially true (again, for me, YMMV) because my MySQL configuration uses a socket for the MySQL port, and the mysql plugin only accepts an int as a port number (not a string where we can pass a unix socket as the port).
Example:
```auto
var mysql = global.get("mysql");
var connection = mysql.createConnection({
host: 'localhost',
user: 'my_cool_dbuser',
port: '/var/run/mysqld/mysqld.sock',
password: 'my_cool_password',
database: 'my_big_amazing_database'
});
```
etc etc
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [28 April 2020 10:20 UTC](https://discourse.nodered.org/t/is-there-any-way-to-do-dynamic-configuration-for-mysql-node-in-node-red/22354/4 "2020-04-28T10:20:42Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.