N8N + MySQL + SSL + unable to get local issuer certificate

I am trying to make MySQL connection and adding credentials and trying to test connection settings. But it throws me error unable to get local issuer certificate

I have filled up host, username, database, port and enabled SSL toggle button. And adding all the contents of a combined-ca-bundled.pem file into the CA Certificate field. The filesize is 64.5 Kb
And i am adding entire content of that file in CA Certificate text field.

However, N8N throws error “unable to get local issuer certificate”.

the connection works fine with DBWeaver, hence there isn’t any connectivity issue or firewall issue. It seems that N8N is not able to read the contents of CA Certificate field.

Please help me resolve this error on N8N.

  1. Check SSL certificate contents for errors.
  2. Use only the full chain certificate in N8N.
  3. Verify SSL certificate path matches.
  4. Restart N8N after making changes.
  5. Ensure SSL certificate hasn’t expired.
  6. Update N8N to the latest version.

Hello,

This is happening when adding a new connection in N8N. It doesn’t have ability to upload certificate files.

So where shall i upload the files? Or how shall i add the entire full-chain certificate while adding a new MYSQL connection?