Error connecting Azure Mysql flexible server to Azure data factory

Question

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.

Answer 1

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.