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.