Importing/Updating credentials

Describe the problem/error/question

I am trying to set up a dev/qa n8n instance, but am a bit lost on how to configure the credentials for our MySQL database. I am using IaC to deploy a new db when doing QA testing, and thus get a new username, password, and endpoint for the database.

I am trying to update our QA n8n credentials for the MySQL db without having to manually change them via the UI. I came across the import credentials CLI command, but am not sure how the data for the credential should be constructed and encrypted.

I would really appreciate any advice on how this can be achieved!

Information on your n8n setup

  • n8n version: 0.221.2
  • Database (default: SQLite): Default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu 22

Hi @dingo-dev :wave: Welcome to the community :tada:

Iā€™m not so sure on this one to be honest - but someone else may jump in here with an answer :bowing_man:

1 Like