Best answer

MySQL “authentication failed” error - are Azure connections are supported?

  • 18 August 2021
  • 4 replies
  • 80 views

Hi,

 

I want to integrate Zapier with an Azure MySQL instance but I get the error commented in this post.

 

Please can you tell me if the connections with Azure MySQL instances enforcing SSL are already supported? And if this is the case, how can I configure my connection?

 

Thanks for your help.

icon

Best answer by SamB 19 October 2021, 11:59

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @AlexBP 

Can you please clarify what Zap app you are trying to use/connect and link to it’s Zap app profile page?

 

Help: https://zapier.com/help/doc/how-get-started-mysql

SSL Client Certificate and SSL Private Key These are fields you can use if you'd like to use MySQL certificate authorization instead of username/password authorization. Notice that you still need to provide a username since the field is required.

Check username, password, SSL certificates

Check for typos, permissions, and spaces at the end of fields and make sure they are all entered correctly.

Hi @Troy Tessalone,

 

i couldn't finish the zap setup due to this problem. I tried to config this Zap: “Create Google Sheets rows from new MySQL rows”.

 

Userlevel 7
Badge +14

@AlexBP 

Consider opening a ticket with Zapier Support: https://zapier.com/app/get-help

Userlevel 7
Badge +11

Just wanted to follow up here as spotted that @AlexBP had reached out to our Support Team and was added to a feature request for Azure support to be added. We’ll be in touch by email as soon as it’s added.

In the meantime, the workaround of “accessing mysql through a virtual machine (azure), and not as a direct service of azure” that’s mentioned in this related thread has been reported to allow Zaps to connect to Azure hosted databases successfully. :)