Getting DB mysql error

sumitrathi · January 28, 2022, 4:49pm

I am getting access denied error while connecting mysql (screenshot attached)
ALso I have added all the AWS IPs in whitelist

pierce · January 28, 2022, 4:59pm

Hi @sumitrathi

Connection errors are so frustrating aren’t they? Sorry to see that.

I assume you’ve double checked your credentials with your local MySQL client, like TablePlus or SequelPro.

Have you made sure that the database’s configuration allows all IPs to connect to it with mysql.conf? How To Allow Remote Access to MySQL | DigitalOcean

You mentioned allowing IP addresses, just not sure if you mean in your AWS EC2 security groups or some other firewall between the MySQL database and this workflow.

sumitrathi · January 28, 2022, 5:06pm

Yes credentials are correct and I am able to connect the database using workbench tool.
I am taking to this list of IPs

pierce · January 28, 2022, 5:10pm

Hi @sumitrathi ,

Thanks for sharing the exact list you’re referring to for IP addresses to whitelist.

In this case those are IP addresses for HTTP requests, not Database connections.

Please refer to this documentation for MySQL and other non HTTP connections: Network / IP range

sumitrathi · January 28, 2022, 5:17pm

thanks for your quick reply.
If I want to connect mysql using above mentioned workflow (mysql.createconnection) then how can I connect

pierce · January 28, 2022, 5:36pm

This link explains how you can setup a MySQL connection through a bastion server:

And here’s an example workflow using SSH tunneling to achieve that: https://pipedream.com/@dylburger/run-a-query-on-mysql-via-ssh-tunnel-p_rvCxrNB/edit

sumitrathi · January 28, 2022, 6:05pm

getting this error

pierce · January 28, 2022, 6:20pm

From what I can I see, it looks like the SSH connection isn’t working. There are number of things to try:

Make sure port 22 is open on the SSH server
Make sure the SSH server is allowing connections from remote IP addresses

The SSH connection is just a security measure for those who can’t allow any IP address to access their MySQL server.

If SSH continues to give you trouble and you’re not restrained by unblocking all IP addresses, then allowing your MySQL server to be connected from any IP address is an option.

sumitrathi · January 28, 2022, 6:36pm

Hi,
SSH part is OK, Now getting connection timeout

pierce · January 28, 2022, 7:42pm

Hi @sumitrathi ,

It looks the host property on like 19 is "localhost" which means that the workflow is trying to connect to MySQL running on itself.

Could you try updating the "localhost" property to match your MySQL server running outside of your workflow?