How can I connect to mysql useing SSL without certificate

Questions
1

Information on your n8n setup

  • **n8n version:**1.109.1
  • **Database (default: SQLite):**postgresdb
  • n8n EXECUTIONS_PROCESS setting (default: own, main):default
  • Running n8n via (Docker, npm, n8n cloud, desktop app):Docker
  • Operating system:linux

I’m trying to connect to a MySQL server using SSL without certificate verification. I have successfully established connections using the following configurations:

JDBC connection url:

jdbc:mysql://192.168.1.211:3306/test_db?useSSL=true&requireSSL=true

Google Database MCP tool configuration:

yaml

sources:
  mysql-source:
    kind: mysql
    host: 192.168.1.211
    port: 3306
    database: test_db
    user: user
    password: password
    queryParams:
      tls: preferred

However, I’m unable to replicate the same SSL connection settings in n8n’s MySQL node configuration. The connection fails despite using similar parameters.

Important constraint: I do not have permission to modify the database server settings.

Has anyone successfully configured SSL connections without certificate verification in n8n’s MySQL node? Any guidance would be greatly appreciated.

2

Hey @happyycm hope all is well. Welcome to the community.

What you’re describing is equivalent to the ‘Ignore SSL Issues’ option in the Postgres node, but looking through the config options, n8n’s MySQL node does not expose such a setting. At the moment the only reliable approaches are either to use a cert signed by a trusted CA, or to add your server’s certificate/CA to the trust store of the system running n8n. Well, or not to use ssl to begin with.