Share via

Error connecting Azure Mysql flexible server to Azure data factory

damiano.crecco 26 Reputation points
2024-02-29T09:33:56.1233333+00:00

Hello, I'm trying to connect Azure Data Factory to Azure MySQL Flexible Server. I've already created a private endpoint to allow Data Factory access to MySQL Flexible Server.

When I use "Azure Database for MySQL" as Linked Service, the connection fails with the error "Access denied for user..." even though it works in MySQL Workbench.

If I use "MySQL" as Linked Service instead, the connection only works if I choose "Legacy" as the driver version. However, I'm unable to save the Linked Service and I get the error: " and error is: Message for the errorCode 'UserErrorInvalidDbConnectionString' not found.".

Is there a way to connect to the flexible server, or am I doing something wrong? Thanks a lot.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. damiano.crecco 26 Reputation points
    2024-03-01T08:16:32.4133333+00:00

    Thanks Satish, I have resolved using Key Vault for connection string password. It looks as though, after I saved it, linked service otherwise does not keep it.

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.