What I need to change in my Credential MySQL? Is there my ip address or something?

Questions
1

I have a problem to connect from running n8n (third-party server) into my local database MySQL Workbench.

Before this, I have connected and successful run n8n desktop in my computer insert into my local database.

image
image1388×685 52.8 KB

This is my successful n8n running insert into my local database.

Error insert db
Error insert db1145×565 74.4 KB

This is my error n8n running from third-party host.

I used same Credential in 2 of n8n running which is my localhost computer and third-party n8n host server.

How do I fix this? Can anyone help me…

I am a newbie or starter.

Information on your n8n setup

  • n8n version:
  • Database you’re using (default: MySQL Workbench):
  • Running n8n with the execution process []:
  • Running n8n via [third-party server : npm, local computer: desktop app]:
2

Hey @farhan_Y,

Welcome to the community :tada:

I have seen that error many times over the year, MySQL is telling you the user and password is probably correct but the user is not allowed to login from that location. When you made the user in MySQL I suspect you set it using 'user'@'localhost' rather than 'user'@'actual-host' or the broader % option which would allow any host to connect.

If you run select user,host from mysql.user it should return the users and let you see the locations they can login from.

1 Like
3

Alright thanks @Jon .