subscription is not allowed to provision in 'France Central'
Hello, I encounter a problem when deploying Azure Database for MySQL flexible server in all my subscriptions in the 'France Central' region, it shows me this error: whereas 3 weeks ago, by doing the same thing, I could deploy without problem,…
VM Extension with publisher 'Microsoft.SqlServer.Management' and type 'SqlIaaSAgent' does not support setting enableAutomaticUpgrade property to true on this subscription."
Hi, I have tried to connect my Azure server and my Azure database to my python project. My python project uses a Tkinter GUI. I'm using both the Azure SQL database and the Azure VM in conjunction. The python app I have designed uses the Tkinter GUI. My…
Unable to connect to MySQL flexible server on Azure on MySQL Workbench on PC.
As the title says, I am unable to connect to the MySQL database that is hosted on Azure through the MySQL workbench app installed on my PC. I always get the error "Could connect to localhost" which is odd Like I followed all of the steps…
sample my.cnf format for Azure database for mysql
Is there a sample document that shows how to configure the user parameter in the .my.cnf file? I can't get this to work [client] host=cluster-1234.mysql.database.azure.com user=adm@cluster-1234
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
How to connect from an azure VPN to an azure SQL server from my PC?
We want from our work computers using an azure VPN to be able to connect/access the databases we have in azure SQL/MySQL. I have read the documentation but I don't understand how it is possible to do this without having to connect from a virtual machine.…
Azure data factory Data Flow: How to delete rows if Specific text in row values
Hi, I have a column in data flow that has Folder Path as Text as below: FileSystem/Folder1/Folder2/Folder3/test.csv FileSystem/Folder1/Folder2/Folder3/test01.csv I want to delete rows that has 01.csv (want to keep only test.csv). I tried using Alter…
![](https://techprofile.blob.core.windows.net/images/GwtaAs6y7E29mww9s0oZbQ.png?8D92F0)
Duplicate tables being created in Azure MySQL Database
Hi, We are facing a strange issue using Azure MySQL databases. recently we noticed that tables with same name are being shown under databases in one of our Azure MySQL database instance. We have no idea how this is possible as we cannot create table…
Azure Container Instance failing to connect to Azure DB for MySQL Instance
I have spun up an ACI based off a custom image hosting a strapi application, that uses the mysql js client to interface with the DB. When accessing the Azure DB for MySQL instance via a local MySQL client or a local docker container, the connection to…
SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server
Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…
MySQL Flexible Server deployment fails
Hello, I am using MySQL Flexible Server as our main DB in our project. And sometimes I have to scale it, but it fails in ~30% cases. There is one of failed message: And also code that running in Azure Portal (I am doing all of it only in…
Unable to Delete Azure Virtual Network
I am attempting to delete an Azure virtual network but keep receiving the error message: "Failed to delete virtual network ''. Error: Subnet iat-5e5de8a6ba-dbsubnet is in use by…
![](https://techprofile.blob.core.windows.net/images/wlnEF7P8aEKyN9Ez5-rpUA.png?8D8A14)
How should I proceed in order to get a HDS certification for my Azure Database for MySQL flexible server?
Hello I am using a Azure Database for MySQL flexible server for my application that is deployed on Azure App Service. I recently heard about the HDS (hébergement des données de santé) in France and I want to obtain it for my database. Reading the…
How to login using AAD with MySQL Workbench?
I am trying to figure out how to login to Azure Database for MySQL using AAD with MySQL Workbench, but this document, although it says it has been tested with Workbench, does not actually provide any details on how to do so:…
![](https://techprofile.blob.core.windows.net/images/aR7AYEMfuUW_0ERnXQ1JWg.png?8D8EB0)
Getting Error "FeatureSwitchNotEnabled" while creating MYSQL through ARM template
Hi All, When I create MySQL through ARM Template there are 2 tasks on which I get FeatureSwitchNotEnabled. 1 - Microsoft.DBforMySQL/servers/firewallRules 2 - Microsoft.DBforMySQL/servers/virtualNetworkRules Do we need to enable any setting to…
Created inbound rule on NSG to allow traffic, no traffic is able to go thought
Current I have a Ubuntu Server running a MySQL database (VM is not only hosting a MySQL database) I created a rule in the NSG to allow traffic to port 3306, but traffic seems to still get blocked when traffic is coming from the internet. For…
![](https://techprofile.blob.core.windows.net/images/yp1iz6RkYkCu5wtHlxsMTQ.png?8D82CB)
Connecting to MySQL Flexible Server in Azure suddenly failing
I have a MySQL instance in Azure which has run fine for about 2+ years. I have a Function App which inserts some data into on a monthly basis which has failed this month with the following error: Result: Failure Exception: InterfaceError: 2026 (HY000):…
Connecting to a Azure MySQL instance from Data Factory Linked Service
I have an Azure Mysql Instance in a Virtual Network created as part of the instance setup. I want to be able to copy data to MYSQL as a Copy Data sink. When I try to set up a connection to the MySQL instance using the AutoResolveIntegrationRuntime it…
Azure Role Based Access Control (RBAC)-what role to assign to outside engineer to help build App Service Laravel app including MySQL Flexible DB
I need to grant temporary access to an outside developer/engineer to access a new Azure App Service Laravel App including MySQL Flexible Database server so they can help set it up, configure it (environment variables, SSH nginx scripts, etc.). They…
To turn off GTID replication in Azure MySQL Database
Hello Team, I am trying to remove GTID data-in replication from my Azure MySQL database instance. I ran the related stored procedure to stop the replication but I am not able to turn off below variables. gtid_mode enforce_gtid_consistency Error: …
Update MySQL Server Create Failed on Azure database for MySQL
I'm trying to create a MySQL server with Azure Database for MySQL functionality. My account is new and I'm still on the free version. I'm trying to do this through the browser. I have tried more than six times, and it always returns the following…