I'm trying connect de MYSQL plugin (zapier) in my RDS Database (aws), but zapier return a error message: "authentication failed: Could not connect with **** and provided password. The response we got from the server is included below for debugging purposes. 255"
I cant find a solution for this error code.
My user, host and password are correct. And the IP 22.214.171.124/32 are enabled in my Security Group. In other integration products, the plugin works.
Best answer by Danvers
In this case, the issue was the version of MySQL being used. Here’s what our Support Team had to say:
This kind of "255" error is MySQL's way of saying that Zapier isn't able to connect with your version of MySQL. Currently, it's not possible for Zapier to connect with MySQL versions of 8.0+
Right now, it would only be possible for Zapier to connect with a database running an earlier version of MySQL. We do have a feature request open to add compatibility with later versions, let us know if you’d like to be added to that feature request!