Intermittent Connection Issues with Azure MySQL Flexible Server (Error P1001 and Lost Connection During Query)
Description: I’m experiencing intermittent connection issues with an Azure Database for MySQL Flexible Server. At times, I’m able to connect, but the connection is frequently lost, especially when trying to fetch schema or run queries. Below are the…
Azure App Gateway, App Services and Database for MySQL Server - Disable public access on App Services
Hello, In Azure I currently have an Application Gateway, two App Services and two Azure Database for MySQL Servers. The two MySQL Database Servers have public access disabled, so it can only be reached through the App Service and/or the VNet. Now, I…
MySQL Single to MySQL Flexible Server Change
It appears that the mysql single server used for my subscription account has been EOSed and forced to migrate to mysql flexible server. However, "Azure Database for MySQL flexible server 'psnm-mcs-p-db-mysql' has been migrated standalone to…
Issue with connection
Hello, I am trying to connect workbench to Flexible server in Azure but not able to connect. I used connection strings and instructions from 'connect' in Azure. Below is the error I am getting: I have disabled SSL in Azure for easier access, added…
Forgot Password
Hi all, I have forgot my sql database password and i cannot use Azure data factory. Any tip on how do i restore my password? Thanks Panos
Not able to create Virtual Network Rule for MySQL flexible server using powershell code
Hello Team , Actually we have IAC infracture to deploy MYSQL DBaaS services. However the existing terraform modules now has been depreciated and we are trying to upgrade the latest terraform module to deploy the same. Now the issue is:- In the existing…
Prevent Public Network Access on Azure App Service with Application Gateway
Hello, I have 2 Web Apps, 2 Azure Databases for MySQL and 1 Application Gateway. It is currently setup so the Azure Databases for MySQL Servers are not accessible by public. They can only be reached through the Web App / VNet. The Web App however is…
How to specify a local timezone on an Azure SQL server?
I have a SQL server on Azure, and I would like to adjust the timezone setting to reflect my local time, which is UTC+8. The current getdate() function shows results in UTC. Is there a way to change the timezone setting to my local time? I am aware of the…
flexibel mysql wont deploy
when i try to deploy a felxible mysql server on azure it gives me the same fault everytime. The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'. (Code: ResourceDeploymentFailure, Target:…
Azure database mysql flexible stuck in "Disabled"-state after upgrading to Pay-as-you-go subscription
Hi folk, As title states. After we upgraded from Free-subcription to Pay-as-you-go subscription, the database went into "Dislabed" state. The status text is the followin: ``The server is currently in disabled state. Please wait for the…
Guidance with MariaDB migration to Azure
Hello, I am currently looking at migrating a MariaDB database hosted on AWS over to Azure as part of a cloud consolidation program. While Azure Database for MariaDB would seem like the most suitable choice, Microsoft has announced that this service will…
What are the steps i need to follow to access Azure flexible database server from the application
Our Database has been migrated from single server instance to flexible server instance. I am not clear about the steps that we need to follow post migration to configure flexible server. Our requirements are as below The Database access is not public.…
Can't Connect to MySQL Flexible Server in Azure
I'm trying to prevent public access to our production MySQL Flexible Server on Azure by using a private Virtual Network (VNet). However, I'm getting the following error when my application tries to connect to the database: getaddrinfo ENOTFOUND…
I cannot deploy a MySQL Flexible database to US EAST
As the title says. Everytime I go to deploy a MySQL Flexible database to US East it fails to deploy. It says to select another region but that service is available in US East according to MS's website which is confusing. How can I resolve…
Azure Database for MySQL flexible server can not start or delete
Azure Database for MySQL flexible server can not start or delete. Always stuck in 'disabled' state. And Ongoing charge.
Unable to delete subnet delegate to Microsoft.DBforMySQL/flexibleServers
I have a subnet delegated to Microsoft.DBforMySQL/flexibleServers. I integrate MySql flexible server to that subnet, for test purpose. Now I delete MySQL server and I want to delete subnet as well, but azure does not allow me to do this. Please help me…
Auto migration from Single server to Flexi server of MySQL server is shown successful, but it is not at all listed anywhere and my apps are not able to connect
There had been an auto migration from my single server MySQL to Flexible server as follow: Migration and cutover to Azure Database for MySQL Flexible Server 'advith-production-mysql-server' completed successfully. While the migrated Flexible Server is…
Issues with MySQL single server migration to Flexible Server
My MySQL single server was migrated to Flexible Server this morning. It has been more than 12 hours and I cannot see the new instance in the azure portal or the azure cli. My application is not able to connect to the new server. In the console I get a…
powerbi on-premises data gateway
I am using azure mysql, however, if I need to access this database from powerbi, should I use a data gateway for "on-premises". As this database reside in the "same" cloud as the de powerbi service, I supposed that the could be…
Cannot access MySQL from Windows VM since auto migration
Hello, We've just had a auto migration from our MySQL single server to MySQL flexible server. After the migration we can connect to the mysql server locally, but not from our windows VM. Since the flexible server is not visible yet we cannot check…