If I have multiple databases in a mysql instance, how do I select the one I want?

Questions
1

Describe the issue/error/question

I am trying to setup a node to pass data coming into n8n through a webhook, to a mysql database. I have multiple databases in the mysql instance, but in n8n I only get asked about which table I want to query. How do I specify the database name?

What is the error message (if any)?

none

Please share the workflow

Share the output returned by the last node

Output is not my issue in this case.

Information on your n8n setup

  • n8n version: 0.186.1
  • Database you’re using (default: SQLite): SQLite
  • Running n8n with the execution process [own(default), main]: own (as I haven’t specified ‘main’ yet)
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: Docker
2

Hi @mickintx, welcome to the community!

You would need to save credentials for each of your databases. Simply open the credentials dropdown and pick Create New:

image

This will let you provide a database name:

image