Hello!
Can’t figure out how to work with MySQL node?
Need help.
I specify in Credentials http://***********7:90/phpmyadmin/
and when Execute Node shows an error: “ERROR: getaddrinfo ENOTFOUND http://***********7:90/phpmyadmin/”
Looks like the port that you have set is incorrect. On port 90 you’re running another service that is enabling you to access PHPMyAdmin. However, MySQL is not running on the same port (unless you have configured to run it on that port instead).
If you haven’t configured the port for MySQL, can you try using the default port in the MySQL credentials in n8n?
I am not sure what is wrong here. My MySQL server is running on Port 8889 and that is what I have set in my n8n credentials. When I execute the node, it works for me.
Can you check if you’re able to connect to your MySQL through a different medium? This will help us know if the issue from n8n or not.
You have a different host set up in your server while we are trying to connect with a different host. Since MySQL is not running on the host that you have configured in the MySQL node in n8n, we are getting the errors. You will have to update the host for your MySQL server.
You have to change the value of the host with the value of the IP address. I would recommend you to checkout the MySQL Forum where you will get a detailed answer.
Can you open a new thread and complete the template provided so that we can look into this for you? This post is over 2 years old now and may contain outdated information.