Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
729 questions
1 answer
(InternalServerError) An unexpected error occured while processing the request
I try to use azure cli to create mysql flexible server I use the following commands: az group create -n mysql -l westus az mysql flexible-server create -n mysqlsql -g mysql -l westus -u mysqlsqlmy -p my1sql+my -d mysql --public-access all --tier…
asked 2021-08-19T09:22:16.117+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(233.6, 89%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
chaowen guo
16
Reputation points
commented 2024-03-28T19:45:26.9033333+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(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
BrikDeBaksteen
0
Reputation points
0 answers
MySQL database on Azure Disappeared from my resources?
I have 2 wordpress websites running on my azure subscription which use the same Mysql database on Azure under the same subscription and resource group. which is nowhere to be found anymore? and both my websites giving error as Error establishing a…
asked 2024-03-25T18:38:47.7533333+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(300.8, 30%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Maneesh
0
Reputation points
commented 2024-03-26T18:28:50.6766667+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How can i back up my Azure DB without the password?
How can i back up my Azure DB without the password? In more detail, i am an Owner of my Azure subscription, which i took over from a colleague who has left the company. I am trying to back up the Azure DB in my subscription but i dont know the password,…
asked 2024-03-21T16:27:22.57+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(240, 3%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Varotsis, Stefanos
20
Reputation points
commented 2024-03-26T13:43:41.5733333+00:00
Varotsis, Stefanos
20
Reputation points
1 answer
Facing error for MySQL connectivity from Synapse Linked Service
I'm trying to created a Linked Service to Mysql Server hosted on AWS Server. But it is giving me: ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server: 10.xx.xx.xx. at port: 3306. with Error Code 9603. My other…
asked 2024-03-21T11:49:26.41+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(288, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sudarshan Bhamare
45
Reputation points
commented 2024-03-26T05:18:00.88+00:00
Sudarshan Bhamare
45
Reputation points
1 answer
Blue Green Deployment of Docker Compose Azure App
I have a docker compose-based Azure App that makes use of Azure MySql Flexible Server and credentials stored in Azure Keyvault. I am wondering if there are any guidelines for blue-green deployment of Docker Compose Azure App. I know Azure App's…
asked 2024-03-25T07:44:05.7566667+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, 33%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUR%3C/text%3E%3C/svg%3E)
Umer Rashid
85
Reputation points
answered 2024-03-25T08:21:01.2333333+00:00
Deepanshu katara
5,920
Reputation points
0 answers
Azure MySQL flexible server not responding after failed attempt of server version upgrade
I tried to upgrade MySQL flexible server from version 5.7 to 8.0 but process got stuck(was keep on running for more than 60min), so I had to cancel the deployment, but after cancelling, I'm not able to update anything in server like updating server…
asked 2024-03-18T17:07:39.7333333+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, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dakornarayan Chandra
5
Reputation points
commented 2024-03-19T17:44:58.48+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
1 answer
MySQL Flexible Servers Deployment is taking a long time/ Unable to delete VNet/Subnet due to serviceAssociationLinks.
Hi, I'm trying to deploy MySQL Flexible Servers, but it's taking too long. As of this writing, the deployment has been running for about an hour. I have successfully deployed before. This time, the difference is that the MySQL server is deployed in a…
asked 2024-03-19T06:13:09.5833333+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(233.6, 86%, 32%)' 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)
Al
21
Reputation points
answered 2024-03-19T08:44:37.1466667+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,081
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
The resource write operation failed to complete successfully, because it reached terminal provisioning state
Hi, I'm on a free tier, and I am trying to deploy a MySQL Flexible server database in East US, and I keep hitting this error: The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'. (Code:…
1 answer
One of the answers was accepted by the question author.
On demand backups for MySQL flexible server. 50 limitation question.
I understand that we have a limit of 50 on demand backups per server. But since the backups have a 7 day retention, does that mean as these backups drop off, that count is restored back? Let's say I run 5 on demand backups on a certain day. This leaves…
asked 2024-02-29T20:19:45.25+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(214.4, 26%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Huffman
20
Reputation points
commented 2024-03-13T16:42:38.98+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
8,756
Reputation points Microsoft Employee
1 answer
How to fix "Your app is currently in read only mode because new Node programming model experience is in preview."
Function app says "Your app is currently in read only mode because new Node programming model experience is in preview." Running v4 and node 18. Using azure blob storage trigger. Metrics show function being called on file upload, however…
asked 2024-02-18T23:07:04.8866667+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(224.00000000000003, 1%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Danny Bui
5
Reputation points
commented 2024-03-12T17:33:05.19+00:00
Pramod Valavala
20,596
Reputation points Microsoft Employee
1 answer
Installing Azure Data studio and SQL Management studio on VM
I have VM with Windows 10 Enterprise. It is 64 bit OS and processer I would like to install Azure Data Studio or SQL management studio do I need to install both? if yes could you please share appropriate links to download and install, thank you which…
asked 2023-10-16T06:34:52.09+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(214.4, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sns
9,226
Reputation points
commented 2024-03-12T16:20:46.9566667+00:00
Jennifer2112
0
Reputation points
1 answer
¿Por qué no aparece mi suscripción gratuita a Azure para poder crear una base de datos?
Hola, no aparece mi suscripción gratuita de azure al momento de querer crear una base de datos MySQL. ¿Qué puedo hacer?
asked 2024-03-07T20:00:53.2366667+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(89.60000000000001, 83%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Luis Alberto Alemán Díaz
0
Reputation points
answered 2024-03-11T12:35:27.99+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, 44%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Claudia Dos Santos Haz (CONCENTRIX CORPORATION)
775
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to do ADF transformation on Specific Rows to Columns
Hello All, I have a transformation that I have tried a few dataflow scenarios that do not yield the results needed. We have a file that exports data like the below sample: COL1****COL2Manufacturing1-Jan-23Baked GoodsLemon CookiesRaw…
![](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(246.4, 38%, 33%)' 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)
1 answer
Unable to connect to mysql flexible server through Vmss.
How can I establish a connection between my MySQL Flexible Server and VM Scale Set (VMSS)? I'm encountering an issue where I'm unable to connect to the MySQL Flexible Server from my VMSS. The error message I'm receiving is "Unable to connect to…
asked 2024-03-06T14:30:37.48+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(137.6, 60%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hrishikesh Mudaye
0
Reputation points
edited a comment 2024-03-08T17:29:20.48+00:00
Oury Ba-MSFT
16,901
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Deployment of MySQL flexible server failed
I am trying to create a MySqlFlexibleServer. However, after going through the wizard, it fails at the deployment step without giving any good feedback. I have no idea how I can fix it. I have tried to repeat the process in different times without any…
asked 2024-03-08T15:27:18.92+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(278.4, 9%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Sara
20
Reputation points
commented 2024-03-08T17:00:07.7533333+00:00
Rahul Randive
8,756
Reputation points Microsoft Employee
2 answers
How to change default_authetication_plugin parameter in Azure MySQL DB
Hello Team, My database error log is getting flooded with below warning messages. I am not able to change the default_authentication_plugin parameter to handle this problem like how we do in the MySQL standalone server. [Warning] [MY-013360] [Server]…
asked 2024-03-07T06:43:22.28+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(294.40000000000003, 43%, 38%)' 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)
Srikar Gondesi - UAS Database Administrator
85
Reputation points
answered 2024-03-08T08:18:42.2+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
Azure Data Factory: denied permission when trying to insert data in Azure MySql8
I have a pipeline to introduce data in Azure Database for MySql from Snowflake, all seems to be ok when I go to the preview data. But when I run the Data Flow activity, the system shows this error: Job failed due to reason: at Sink 'outmysql': CREATE…
![](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(208, 40%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
How to fix delayed TDS version error with pymssql when running backend app service
I have an issue when deploying my python flask application, it connects to an azure db using pymssql. For about an hour after deployment, there are no issues and the flask server works as intended. However, after a bit this error starts to show up and…
asked 2024-03-06T22:24:10.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(172.8, 51%, 26%)' 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)
Jakob B
0
Reputation points
answered 2024-03-07T04:57:34.1633333+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
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: …
asked 2024-03-04T10:38:48.5033333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
answered 2024-03-05T02:36:35.74+00:00
Rahul Randive
8,756
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why do I need to create a support request for already enabled region for my Azure Database MYSQL
Hello Team, Just out of curiosity, why do I have to request a region access if I had the access to a particular region few months back. Recently while deploying Azure database MySQL, I had access to the WE region however I had to raise a request and get…
asked 2024-02-29T12:09:00.07+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(64, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Learn Cloud
80
Reputation points
edited the question 2024-03-04T19:37:55.25+00:00
deherman-MSFT
34,041
Reputation points Microsoft Employee