@Zagato36 - I have currently had to put my app pool user in the local admins group on my web server, otherwise my web pages cannot connect to Azure for MySQL. That's not an ideal situation. I don't mind giving the account certain permissions it needs, but I'm at a loss as to what those might be.
I'm not using SSL to connect to MySQL - I'm porting an existing application onto the Azure infrastructure and want to do so with as few changes as possible. So I don't believe I'm using a certificate to connect to the database. My connection string is:
DRIVER={MySQL ODBC 8.0 Unicode Driver};SERVER=xxxx.mysql.database.azure.com;DATABASE=mydatabase
I'm using odbc_connect in PHP to connect to the database.
It feels like the account that needs to connect to the Azure MySQL database needs permissions to look up the host name and connect to the internet, but I'm not sure how much sense that makes.
Any help and advice you could offer would be greatly appreciated.
Thanks,
Al.