Hi. I am trying to connect to MySQL with Zapier via a webhook. They I have added access control for the for 220.127.116.11/32. And ranthe following commands:
CREATE USER 'zapier'@'18.104.22.168' IDENTIFIED BY 'password';
GRANT SELECT, INSERT ON your_database.your_table TO 'zapier'@'22.214.171.124' IDENTIFIED BY 'password';
I am still getting an error.
"We hit an error adding your new account
authentication failed: Could not connect with firstname.lastname@example.org and provided password. The response we got from the server is included below for debugging purposes. (pymysql.err.OperationalError) (2059, "Authentication plugin 'b'sha256_password'' not configured") (Background on this error at: http://sqlalche.me/e/e3q8)"
I am out of ideas on how to fix this issue. It could be a problem with the certificate not being trusted, but I don't know how to fix that.
Has anyone else seen this issue?