Mysql node config externally

#1

Hi,
I am using mysql node and successfully connect to my DB. Mysql node is currently configured from the node settings; such as "Host", "User", "Password" entries.
I would like to send these config parameters externally, using a function node for instance rather than hardcoding in the node settings.
The reason for this is, within the same project I will need to access different databases depending on the credentials I receive from a login page. Therefore, I need to make mysql config dynamic.

Any advice is appreciated.
Thanks

0 Likes

#2

Are the databases duplicates of each other (ie same tables and columns)? Or are they different tables in the different tables?

At any rate the user and passwords are not setable outside the node.

0 Likes

#3

Databases have the same structure, except for the data will be different.
I can duplicate the mysql node as much as client number, but that wouldn't be very practical.

Do you have any suggestions?
Thanks

0 Likes

#4

Not really, maybe someone else will pipe in.

0 Likes