Error connecting to MySQL from Zapier

Hi. I am trying to connect to MySQL with Zapier via a webhook. They I have added access control for their ip as was suggested by their help. 54.86.9.50/32. And run the following commands:

CREATE USER 'zapier'@'54.86.9.50' IDENTIFIED BY 'password';
GRANT SELECT, INSERT ON your_database.your_table TO 'zapier'@'54.86.9.50' IDENTIFIED BY 'password';

I am still getting an error.

"We hit an error adding your new account
authentication failed: Could not connect with zapier@54.86.9.50 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?

Thanks,

Rhonda