I created a user with all privileges in DB, allowed access from 54.86.9.50 to DB. When I connect from CLI to DB I'm successful, but when I enter the same credentials to Zapier I get error
authentication failed: Could not connect with zapier@olvin and provided password. The response we got from the server is included below for debugging purposes. (pymysql.err.InternalError) (1043, 'Bad handshake')
MySQL is running version 5.7
When I enforce SSL on DB and enter contents of https://www.digicert.com/CACerts/BaltimoreCyberTrustRoot.crt.pem (see https://docs.microsoft.com/en-us/azure/mysql/concepts-ssl-connection-security) to SSL Client Certificate field, I get error
authentication failed: Could not connect with zapier@olvin-dev and provided password. The response we got from the server is included below for debugging purposes. [SSL] PEM lib (_ssl.c:3358)
Can someone please help with connecting?