Unable to connect to any of the specified MySQL hosts. Once deployed, locally it works

Question

Client->Function->Key Vault Secrets->Function->Database for MySQL->Function->Client

I'm using C# Visual Studio, i have created a function that gets secrets from the key vault for my SQL connection. I have created a database and table with some basic data.

When I run the application locally I can connect and retrieve the data either through chrome or postman.

Once i deploy the application i get the following message

Unable to connect to any of the specified MySQL hosts.

I know I'm missing a setting somewhere but I don't know where

thanks

Marc

Answer 1

l don't have half those values, and my local.settings.json is default

{
    "IsEncrypted": false,
    "Values": {
        "AzureWebJobsStorage": "UseDevelopmentStorage=true",
        "FUNCTIONS_WORKER_RUNTIME": "dotnet"
    }
}

here are the two lines from my log, you can see it got the secrets and then failed to connect to the Db

2023-01-20 02:54:49.935

Number of Secrets Found is : 4

Information

2023-01-20 02:55:05.002

Unable to connect to any of the specified MySQL hosts.

Error

Answer 2

so i figured it out do i need to have both these on or is one or the other enough

either or both allows it to work but which is safer

thank

Marc

Answer 3

i ended up getting all of the outbound ips from the functions and adding them to the mysql firewall rules

is this the correct approach