Error connecting mysql to database

[Alfredo_Villa]

I’m trying to connect a mysql module to a database.
From Navicat and other connections it’s working fine with the supplied credentials.
But in N8N I get a connection error.

I’ve already added the n8n ips (20.79.72.105-20.79.72.36-20.79.72.0
/24)

About n8n - web

n8n Version1.72.1
Source Codehttps://github.com/n8n-io/n8n
LicenseSustainable Use License + n8n Enterprise License
Instance ID55c9e8edbc51455e6c8c40901fb4c0fa59cff789364f59c4be975fe6a9f3a6ef

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

[Jon]

Hey @Alfredo_Villa,

Welcome to the community

Can you try the execute query option and try something like select @@version and share the error if any that will give us an idea of what is failing.