I have to upload images to a MYSQL DB, which requires using the load_file command. Since it’s an RDS database however, it doesn’t have a server connected to it, so load_file fails. That’s the reason I’m using Workbench.

I’m having issues with the connectivity part, and I’ve exhausted other recommendations. The specific error I get is:

“Your connection attempt failed for user ” at the MySQL Server at ”: unable to conenct to localhost

For the AWS side of things:
I’ve ensured that the security group takes the connection
I’ve ensured that the database is publicly accessible
I’ve ensured the endpoint is valid (I’m running code interacting with the DB and can connect fine)

I’ve went over all of the configs twice over, but nothings seeming to stick.
I’ve attempted telnet <ip/dn> and that’s failed, but I’m not sure why. My security group has an inbound rule allowing any connection from any port, which I understand is unsafe but it’s temporary and for troubleshooting.