Connect to Mysql fails on both remote and local servers

Questions
1

Describe the problem/error/question

I am trialing n8n to connect to a hosted MySQL. All setups fail with connect ETIMEDOUT error. The credentials are correct and database can be accessed from my browser. I am also testing against a local instance of the database, and get error connect ECONNREFUSED 127.0.0.1:3306

What is the error message (if any)?

Please share your workflow

Simple test using your template - export table to Excel

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

Can you try with just the IP and not specifying the port?

3

I have tried the IP address for the hosted server - same error. I have tried localhost and 127.0.0.1 for the test instance - no difference.

4

I’m away from my computer right now. I will test it out when I get home. I usually use postgres so can’t remember the n8n MySQL setup from the top of my head

5

No reply received from n8n! There was a single reply from a user that offered no help.

6

Hey,
Are you trying to run n8n with Mysql or tryin to connect to mysqldb in a workflow?

Mysql/ MariaDB are not supported anymore: n8n v1.0 migration guide | n8n Docs

7

mysql server needs to allow remote connections.