Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
1 answer
Active connections when database not open to public access
I have an Azure MySQL database which is currently running a high daily cost just in IO operations, even on days when I'm not using the database. I'm trying to cut costs and I noticed that I have an average of 100 select queries being run every 5 minutes…
asked 2024-06-04T16:34:22.6366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 20%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mark Buckley
20
Reputation points
commented 2024-06-24T15:52:17.3266667+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
0 answers
I have a single server databases for MySQL Flexible Server located in the North Central US region only.
I have a single server databases for MySQL Flexible Server located in the North Central US region only and today I had this error indicates that the operation was canceled before it could be completed. The error stack trace points to a JavaScript file…
asked 2024-06-19T17:02:03.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 22%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Schifter, Gabriela
160
Reputation points
asked 2024-06-19T17:02:03.78+00:00
Schifter, Gabriela
160
Reputation points
1 answer
How to fix "An error has occurred. The target schema is in an unknown state" on Windows PC (VS Professional 2022)?
Hello there, i tried to compare and update schema few months ago. But i performed the wrong action. I set the source and target in the opposite way and updated. after that i also incorrectly performed a Post Deployment script which is not required.…
asked 2024-06-14T02:22:02.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lu, Yiling (SI BSW OPS TECH SW-ENG 3)
0
Reputation points
commented 2024-06-19T07:33:30.4066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
1 answer
How to stop sql_generate_invisible_primary_key generation when migrating Access database to Azure MySQL
After import of Access table to Azure MySQL instance database, an invisible primary key is automatically generated. 'SHOW VARIABLES LIKE "sql_generate_invisible_primary_key";' shows 'ON'. Trying to 'SET GLOBAL sql_generate_invisible_primary_key…
asked 2024-06-10T21:07:18.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GScavello
0
Reputation points
commented 2024-06-18T23:48:41.63+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
What are different ways I can host my Oracle database in Azure managed by Azure?
What are different ways I can host my Oracle database in Azure managed by Azure?
asked 2024-06-17T17:03:36.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 73%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
manish shah
0
Reputation points
answered 2024-06-18T15:55:30.5233333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
1 answer
Azure MySQL Database for Flexible Server System Tables Corrupted
I have maintained a Azure mySQL database for Flexible server for over a year. It works fine until yesterday. When I try to connect using mySQL Workbench, it can connect to the server but it cannot fetch any tables / views / SP / Functions information. I…
asked 2024-06-18T10:11:30.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
WorkingBear
0
Reputation points
answered 2024-06-18T10:35:20.2+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
0 answers
Wordpress on Azure App Service : Database Error - Error Establishing a database connection [Azure Marketplace deployment]
Hi! I have deployed a Wordpress site onto the Azure App Service using the Azure Marketplace plugin called Wordpress on App Service by Microsoft. It deployed the following resources onto my resource group: The problem is, although the web app is up and…
asked 2024-06-09T08:17:56.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 95%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Swapnanil Ray
0
Reputation points
commented 2024-06-17T10:49:08.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ajkuma
24,396
Reputation points Microsoft Employee
1 answer
Can't access a database after trying to delete it.
I created a database in Azure database for MySQL, flexible server. The database was used and a couple of tables in it have thousands of records. I want to drop the database, but I keep having a timeout. I then went to Azure portal to delete the database…
asked 2024-06-16T14:05:17.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 51%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Damien Doumer
0
Reputation points
answered 2024-06-17T04:56:50.99+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
1 answer
How do I fix "InternalServerError" while deploying Azure Database for MySQL Flexible Server?
There seems to be a bug with deploying Azure Database for MySQL Flexible Server. If there are no available Skus in the region I want to deploy to, I get a deployment error with status "Conflict", error code "InternalServerError" and…
asked 2024-06-16T11:09:54.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 71%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Manuel T
0
Reputation points
answered 2024-06-17T02:45:48.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
9,091
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
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…
asked 2024-05-24T02:26:50.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Syaza Liyana
20
Reputation points
accepted 2024-06-11T02:47:28.17+00:00
Syaza Liyana
20
Reputation points
2 answers
100% CPU on Empty MySQL Instance
Hello, I recently setup an Azure mySQL Database. It is type Standard_B1s (small yes). I have not created any databases at all. The only thing in there is the default database mySQL comes with. There are no users, no-one connecting to it. Looking at…
asked 2024-04-01T23:18:33.1233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jason Bennett
15
Reputation points
commented 2024-06-10T14:40:16.8566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 57.99999999999999%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Phillip Parr
20
Reputation points
1 answer
Getting Internal error while migrating single server to flex mysql server
Getting InternalServerError while running a flex server migration in poc env az mysql flexible-server import create --data-source-type 'mysql_single' --data-source 'server' --resource-group 'poc-infra-rg' --name 'flexserv-01' --key…
asked 2024-06-10T11:21:03.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 28.999999999999996%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Varadarajan, Anandji
0
Reputation points
answered 2024-06-10T14:38:28.6133333+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Can't connect to Azure MySQL flexible server
I'm getting the following error in MySQL workbench when trying to connect to my server I cant connect from my program either. When I logged into the Azure portal, a message popped up saying I have used up all my SKU credits despite not having done…
asked 2024-06-05T21:42:31+00:00
Mark Buckley
20
Reputation points
edited an answer 2024-06-07T20:02:28.8633333+00:00
GeethaThatipatri-MSFT
29,007
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
SQL Server Migration Assistant for MySQL download page 404s
Hi, I was trying to download the SQL Server Migration Assistant for MySQL tool, but the link to download the latest version of the tool leads to a 404 page. See https://aka.ms/ssmaformysql, and this page was last updated in mid-late 2023 and has no…
asked 2024-06-05T20:12:20.2533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 65%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Matthew Frederick
20
Reputation points
edited a comment 2024-06-06T11:05:39.6166667+00:00
Viorel
114.1K
Reputation points
3 answers
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…
asked 2023-10-10T15:33:47.4133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENE%3C/text%3E%3C/svg%3E)
Navid Erfani-Ghadimi
0
Reputation points
commented 2024-06-03T13:57:20.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 61%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sérgio Miguel R. P. da Silva
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Clarification on In-Place Migration Eligibility for Azure Database for MySQL Server
Dear Azure Support Team, I received a notification stating that our Azure Database for MySQL server is scheduled for in-place migration to Flexible Server during the maintenance window of 01/07/2024 - 02/07/2024, 23:00 - 05:00 UTC. However, our server…
asked 2024-05-28T14:05:26.17+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cosmina Alexandra Jelea (RO)
165
Reputation points
accepted 2024-06-03T05:16:25.5033333+00:00
Cosmina Alexandra Jelea (RO)
165
Reputation points
1 answer
I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity, while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external table.
I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity. while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external…
asked 2024-05-29T06:41:24.1733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 57.99999999999999%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sodhi, Harkrishan
0
Reputation points
answered 2024-05-29T12:08:13.1+00:00
ShaktiSingh-MSFT
14,276
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Daily dump mysql flexible servers databases to storage account blob container
Hi folks ! I have a mysql flexible database server with 2 databases, each database is about 50 Gb. The aim is to mysqldump daily and copy the dumps file to an azure storage account. I tried to achieve it by using an azure devops scheduled pipeline using…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 60%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
Azure Database for MySQl Flexible - High CPU - No increase in workload
I have an Azure Web App that is connected to an Azure Database for MySQL Flexible server. This web app is a small data collection form that stores the collected values to a table which are later collected via am API in the web app. A cron job executes…
asked 2024-04-03T11:31:42.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jon Bromley
15
Reputation points
commented 2024-05-27T19:36:59.5633333+00:00
Phillip Parr
20
Reputation points
1 answer
Issue with Azure mysql database for flexible server connection to azure app service. driver not found in sql server
org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [loginServlet] in context with path [/myshuttledev] threw exception [Servlet execution threw an exception] with root causejava.lang.ExceptionInInitializerError:…
asked 2024-05-20T18:55:03.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 27%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
abhi
0
Reputation points
answered 2024-05-23T17:49:54.6166667+00:00
Oury Ba-MSFT
17,631
Reputation points Microsoft Employee