Error node n8n when connecting to mysql outside of railway

almonato
HOBBY

3 months ago

I created a flow in n8n, and when I tried to configure a MySQL node, the credentials were tested through Workbench and MySQL Shell, which means the remote MySQL is accepting remote connections correctly with the credentials entered.

I also added Railway's IP address.

And I can't get n8n to connect to the remote MySQL.

Is there a restriction on outgoing connections?

What should I do?

Thank you.

Awaiting User Response

1 Replies

chandrika
EMPLOYEE

3 months ago

Hey there, We don't restrict outgoing connections on Railway, so the issue isn't related to outbound traffic limitations from our platform.

A few things to check:

  1. Confirm you're using the correct port in your n8n MySQL node configuration (default is 3306)

  2. Double-check the database name is correct in n8n

  3. Ensure the MySQL user has sufficient privileges for the operations you're trying to perform

  4. Check if your MySQL server requires SSL connections and configure that correctly in n8n

  5. Verify that the hostname/IP you're using in n8n matches exactly what you've allowed in your MySQL configuration

  6. Ensure the MySQL server’s firewall is configured to allow connections from Railway's IP

Status changed to Awaiting User Response railway[bot] • 3 months ago