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 54.86.9.50/32 are enabled in my Security Group. In other integration products, the plugin works.
Best answer by Danvers
Hi
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!
+11Hey
I’m afraid I don’t have the full details of how to set up the proxy, as I didn’t set it up myself. The workaround I shared above was passed onto us from a customer that was able to get it working. I did some digging on the mySQL website and was able to find the following guide on setting up proxy users: MySQL 8.0 Reference Manual > Proxy Users
I’m not sure if that’s the same method that was used for creating the proxy but hopefully that guide is helpful. :)
Hi there,
is this connection problem solved?
I tried connect our MYSQL Database with Zapier. but it’s not working. (error code 255)
our MYSQL version upper then 8.0
Should I added list something?
Or someone can check this for me?
+11Hey
I’ve just double-checked and it’s not been sorted yet, unfortunately. I’ve added you to the list of affected users. We still don’t have an ETA on when this will be resolved but will email you and update the thread here once it is.
+9Hi there,
I’ve got your vote added to that feature request. We’ll be in touch via email with any updates if and when this gets implemented. 🙂
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
