Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
848 questions
1 answer
Error Deploying Azure QuickStart API Builder: SQL Database Unavailable in any location
Hi all, I'm new to azure and am on the free trial and I have been trying to follow this guide to get started on APIs within Azure, https://learn.microsoft.com/en-us/azure/data-api-builder/quickstart-azure-sql. But once I get to deploying the static web…
asked 2024-11-06T16:07:33.23+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, 32%, 16%)' 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)
Christopher Ajayi
0
Reputation points
commented 2024-11-07T23:00:27.24+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
725
Reputation points Microsoft Vendor
0 answers
How to fix 'Couldn't interpret '0000-07-01' as a valid DateTime' Error in copy activity - synapse analytics pipeline
Hello, Synapse analytics-copy data activity returning below error. But in my case many rows are having "0000-07-01" date in the DB table column. I have tried to change the datatype then to debug. But failed to copy. And then I tried copy…
asked 2024-11-04T15:16:05.7266667+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, 35%, 20%)' 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)
Shrimathi M
40
Reputation points
commented 2024-11-07T18:45:53.3366667+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
16,735
Reputation points Microsoft Vendor
1 answer
Azure data sync tables are not updated on portal
I have added two tables to sync-group through power shell script. But the tables are not selected in table list. I refreshed schema , still the tables add to sync-group is not selected.
asked 2024-11-06T15:41:47.6866667+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(249.60000000000002, 87%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aparna Manoharan
20
Reputation points
edited a comment 2024-11-07T17:59:50.8633333+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, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
405
Reputation points Microsoft Vendor
0 answers
How to access a mySQL Flexible server in a vNet from local PC
Hi community, I have an Azure Database for MySQL flexible server inside a vNet and I want to be able to access it from my local PC in order to restore back up files we are migrating from another DB. Is there anyway to do this that does not involve a VM…
asked 2024-11-05T14:11:09.32+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, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Reegan Alward
0
Reputation points
commented 2024-11-07T17:13:34.7533333+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
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…
asked 2024-09-18T14:01:28.27+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(70.4, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Mykhailo Vasylchenko
0
Reputation points
commented 2024-11-07T11:11:39.96+00:00
Mykhailo Vasylchenko
0
Reputation points
0 answers
Get backup of Azure Database for MySQL single server
Azure Database for MySQL 単一サーバーからフレキシブルサーバーへの自動移行がされており、単一サーバーが停止状態になっています。 単一サーバーの起動ができないのですが、バックアップを取得する方法はあるでしょうか？
asked 2024-11-07T10:30:17.2166667+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(227.2, 84%, 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)
翔太郎 梶
0
Reputation points
commented 2024-11-07T11:10:38.1433333+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,105
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Can't deploy Azure Database for MySQL flexible server in some regions.
I tried to deploy Azure DB for MySQL flexible server 2 weeks ago. However, I get an unknown error and cannot deploy. When I try to create a MySQL flexible server in the Azure portal, I get the following message when I select a specific region. …
![](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(38.4, 19%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
![](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, 7.000000000000001%, 39%)' 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)
2 answers
I am having difficulty getting a copy of the mysql database for a wordpress site.
I am attempting to copy the entire Azure MYSQL database but am unable to do so. I try to do a restore and it validates it as possible but then it fails something about being in the wrong zone or no permissions on the zone, it should not be this difficult…
asked 2024-11-05T18:15:04.12+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(211.20000000000002, 59%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
David Kendall
1
Reputation point
answered 2024-11-06T18:22:56.6866667+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure SQL Database vs Azure Database for MySQL
"I'm working on a project We're considering using either Azure SQL Database or Azure Database for MySQL for the relational data. I've noticed that Azure SQL Database tends to be more expensive. Can someone explain the main differences between Azure…
asked 2024-08-27T22:27:41.3766667+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(0, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Likitha Bommasani
20
Reputation points
accepted 2024-11-01T20:58:05.7066667+00:00
Likitha Bommasani
20
Reputation points
1 answer
The command cannot be executed on the terminal
The command cannot be executed on the terminal
asked 2024-10-28T09:45:59.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(22.400000000000002, 78%, 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)
鱼 江
0
Reputation points
commented 2024-11-01T13:38:07.0066667+00:00
NIKHILA NETHIKUNTA
3,105
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Need help in creating a custom policy which will auto remediate MySQL Flexible servers to TLS Version 1.2
I need help in creating a azure policy which will auto remediate MySQL Flexible Server from Older TLS Versions to Newer TLS Version (Version 1.2).
asked 2024-10-25T15:03:20.06+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(182.40000000000003, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESU%3C/text%3E%3C/svg%3E)
Sumeet Upadhyay
25
Reputation points
accepted 2024-10-30T11:34:46.1166667+00:00
Sumeet Upadhyay
25
Reputation points
1 answer
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
asked 2024-10-21T16:14:43.2666667+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(96, 89%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEP%3C/text%3E%3C/svg%3E)
Emmanouilidis, Panos
0
Reputation points
commented 2024-10-29T16:50:13.1833333+00:00
Emmanouilidis, Panos
0
Reputation points
1 answer
One of the answers was accepted by the question author.
I have an Azure for stundents account. Is there any way I can create free MySQL database using this account?
I am a student currently learning about using MySQL Azure database. I want to create new MySQL database on Azure under the "Azure for students" plan. However all the options mentioned are paid. Is there any way I can do it for free?
asked 2022-07-15T08:07:14.233+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(163.2, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Sián
21
Reputation points
commented 2024-10-28T08:35:09.7833333+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(163.2, 82%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Sandeep J Shivashettar
0
Reputation points
1 answer
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.
asked 2024-09-12T09:18:40.9366667+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(54.400000000000006, 42%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYC%3C/text%3E%3C/svg%3E)
Yayun Chang
0
Reputation points
edited a comment 2024-10-25T08:44:36.4366667+00:00
Yayun Chang
0
Reputation points
1 answer
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…
asked 2024-10-17T14:44:27.3533333+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(169.60000000000002, 96%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM7%3C/text%3E%3C/svg%3E)
MONDALABDULKADIR-7547
25
Reputation points
commented 2024-10-24T17:50:08.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(198.4, 69%, 29%)' 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)
Sai Raghunadh M
1,045
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-10-22T09:35:24.2433333+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, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Varun Jayarama
0
Reputation points
commented 2024-10-24T13:14:18.6966667+00:00
Mahesh Kurva
725
Reputation points Microsoft Vendor
1 answer
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…
asked 2024-10-21T23:54:26.0433333+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, 8%, 25%)' 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)
이중문
0
Reputation points
commented 2024-10-24T12:44:38.7866667+00:00
NIKHILA NETHIKUNTA
3,105
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
asked 2024-10-23T06:54:44.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(121.6, 83%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Rajeev C
20
Reputation points
edited the question 2024-10-23T21:50:09.7733333+00:00
Erland Sommarskog
112.7K
Reputation points MVP
2 answers
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…
asked 2024-10-21T17:01:29.02+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, 69%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Panjwani, Dhiral D (Campus)
5
Reputation points
answered 2024-10-23T20:40:31.5533333+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
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:…
asked 2024-10-18T23:22:09.1566667+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, 30%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Diangelo Emerencia
0
Reputation points
commented 2024-10-22T17:03:32.71+00:00
NIKHILA NETHIKUNTA
3,105
Reputation points Microsoft Vendor