Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 questions
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,636
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
![](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,596
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
![](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
13,751
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
13,751
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,596
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
33,701
Reputation points Microsoft Employee
2 answers
SQL MANAGED INSTANCE STORAGE LIMIT INCREASE
Can we request for an increase of Storage capacity of a SQL Managed Instance Of General pupose of with Hardware configuration of Standard series of 16 TB storage capacity. The storage capacity has reached 16 TB now.Kindly let us know if we can request…
asked 2024-02-27T13:30:27.1133333+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(48, 16%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tamil Selvan M
0
Reputation points
commented 2024-03-04T16:51:51.4433333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
Troubleshooting Connection to Azure Flexible Server with MySQL Workbench
Hello, I'm having trouble connecting to an Azure Database for MySQL flexible server using MySQL Workbench. Even though my IP is whitelisted, and the port is allowed in my Windows firewall settings, I'm still unable to connect. For more information,…
asked 2024-03-01T12:14:14.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, 33%, 19%)' 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)
Samer Hajjar
0
Reputation points
commented 2024-03-01T17:21:21.04+00:00
TP
77,076
Reputation points
2 answers
unable to delete a virtual network in Azure due to a service association link
I'm being billed at least $50 a month for a virtual network which I don't use and am unable to delete. It appears the issue is a subnet is assigned to Microsoft.DBforMySQL/flexibleservers. If I try to delete the subnet, or assign the subnet delegation…
asked 2024-02-13T14:35:59+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, 94%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Yosef
0
Reputation points
commented 2024-02-29T21:27:44.5666667+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' %3ECM%3C/text%3E%3C/svg%3E)
ChaitanyaNaykodi-MSFT
23,106
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Regarding the announcement of "End of support for Azure Database for MySQL single server"
[https://learn.microsoft.com/ja-jp/azure/mysql/single-server/whats-happening-to-mysql-single-server#migrate-from-single-server-to-flexible-server ](https://learn.microsoft.com/ja-jp/azure/mysql/single-server/whats-happening-to-mysql-single-server#migrate-…
![](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(128, 69%, 22%)' 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)
1 answer
One of the answers was accepted by the question author.
Mysql database has gone into "Disabled" state
Mysql database has gone into "Disabled" state "The server is currently in inaccessible state. Please wait for the operation to complete. You can refresh to check status. Reach out to Microsoft support if the operation is taking too…
asked 2024-02-29T05:08:07.3333333+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(115.19999999999999, 23%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Azam Iftikhar
20
Reputation points
edited the question 2024-02-29T06:42:23.0766667+00:00
Azam Iftikhar
20
Reputation points
1 answer
We need automation for taking backup and restore daily base for on-prem mysql database
We need automation for taking backup and restore daily base for on-prem mysql database, we using the tool for my sql is mysql- work bench
asked 2024-02-28T12:04:25.1166667+00:00
Tamil Selvan M
0
Reputation points
answered 2024-02-28T15:09:47.54+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to fix error "The resource write operation failed to complete successfully, because it reached terminal provisioning state Failed" while creating Azure Mysql Flexible server
Hi Team, I am getting below error when i try to create Azure Database for MySQL servers. { "status": "Failed", "error": { "code": "InternalServerError", "message":…
asked 2024-02-28T11:58:31.7166667+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(9.6, 59%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rohith
20
Reputation points
commented 2024-02-28T13:25:03.8266667+00:00
Rahul Randive
8,596
Reputation points Microsoft Employee
2 answers
ADF copy activity is failed due to the source side error
Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Divide by zero error…
asked 2022-12-22T12:11:15.107+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(185.6, 64%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ramanjaneyulu, Maram Venkata
6
Reputation points
answered 2024-02-27T03:25:40.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(176, 88%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahmad azad
0
Reputation points
1 answer
Test Connection failure in Linked Service in data factory while connecting to DB2
Expectation: Data transfer from DB2 to SQL Server Details : While providing all details in the linked service the test connection it getting failed, can you please let me know if whitelisting my IR public IP will resolve it? ERROR details : Cannot…
asked 2024-02-22T09:59:55.43+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(25.6, 47%, 12%)' 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)
ADMMMLIFEADFADMIN
0
Reputation points
commented 2024-02-26T20:01:57.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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,496
Reputation points Microsoft Employee
2 answers
MySQL Flexible Server Skus missing from EastUS and EastUS2 region
The following to calls to list MySQL Flexible Server skus for the east US region return no values. What gives? In the Azure Portal, it acts as though I can create servers in those regions but creation fails with a undescriptive error. az mysql…
asked 2024-02-21T12:33:54.67+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(112.00000000000001, 63%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFG%3C/text%3E%3C/svg%3E)
Fred Gohsman
0
Reputation points
commented 2024-02-26T19:42:48.34+00:00
BhargavaGunnam-MSFT
26,496
Reputation points Microsoft Employee