Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
750 questions
1 answer
Azure Database for MySQL flexible server unexpected increase in CPU usage
I'm running a base B-tier burstable Azure Database for MySQL instance that holds the data for a Strapi CMS backend for a client NextJS website. The CMS and subsequently the database are are not being accessed regularly, only for data updates and the…
asked 2024-05-07T19:57:52.45+00:00
Owen Abkes
0
Reputation points
commented 2024-05-08T20:35:22.72+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server
Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…
asked 2021-05-03T11:51:51.583+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(80, 74%, 17%)' 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)
Lynn Carelse
21
Reputation points
answered 2024-05-06T23:54:14.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(294.40000000000003, 6%, 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)
Santiago Guerrero Toro
0
Reputation points
1 answer
Azure database for MySQL - foreign key checks option
Hello M, Can you help us with a variable to manage the foreign_key_checks option is basic variable to migrate data.
asked 2021-10-14T15:05:39.163+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, 98%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jesus Gaibor Yanez
1
Reputation point
commented 2024-05-06T16:26:47.0766667+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(32, 87%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Dario Carta Mantiglia
5
Reputation points
0 answers
!!Email_me_if_you_want_your_database_dbfile@proton.me
!!Email_me_if_you_want_your_database_dbfile@proton.me This appeared in my MySql server on an Azure VM. They also deleted 30 database. It looks like it is an empty database and they just used the name to send a message. The database can not be dropped Is…
asked 2024-05-03T09:07:59.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(259.20000000000005, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Phillip Hamilton
0
Reputation points
commented 2024-05-04T07:34:27.2833333+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, 13%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sailesh kumar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Using REPLICATE_REWRITE_DB in Azure MySQL database
Database names in my Master and Replica server are different. Master DB name - uas-tms-20211111 Slave DB name - uas-tms-uat To get the replication working in this scenario, we use REPLICATE_REWRITE_DB option in on-prem MySQL servers. …
asked 2024-04-23T12:20:53.6433333+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
commented 2024-04-29T12:18:04.9633333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
1 answer
Azure MySQL Flexible Server Extremely Slow
I have a database server (MySQL Flexible) and it was working fine, but the last few days it has become very slow. There were no changes in the application, the code of application did not change. In the information_schema.processlist there are no active…
asked 2024-04-04T16:08:44.34+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, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Igor Deutsch
0
Reputation points
commented 2024-04-27T10:21:15.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(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,011
Reputation points Microsoft Employee
1 answer
Deployment for MySQL server fails
I'm trying to set up my first MySQL server on azure, but deployment keeps failing with error: { "status": "Failed", "error": { "code": "AzureKeyVaultKeyNotFound", …
asked 2023-04-20T07:53:50.0966667+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(57.599999999999994, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
»CLØnÊ« Who
0
Reputation points
commented 2024-04-27T10:09:43.21+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(105.60000000000001, 42%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Murphy
0
Reputation points
2 answers
Deleted table restore
Is it possible to recover the deleted table in azure database ? if yes please tell me how ?
asked 2024-04-26T01:28:18.4566667+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, 47%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
VIKAS GOLE
0
Reputation points
answered 2024-04-26T03:51:00.6133333+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,201
Reputation points Microsoft Employee
2 answers
Unable to create an Azure MySQL flexible server
I am receiving an error message when trying to create a new Azure MySQL flexible server database in the Southeast Asia region. The error states that "Subscription <name> is not allowed to provision in Southeast Asia." I already have one…
asked 2024-02-26T06:13:34.3666667+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(28.799999999999997, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LonLee
11
Reputation points
commented 2024-04-24T05:28:33.35+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(188.79999999999998, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Elvin Cheah
0
Reputation points
2 answers
Is there any transactional SQL for creating firewall rule using sp_set_firewall_rule in Azure MI
Hi Team, Can you please let us know, is there any transactional SQL for creating firewall rules using sp_set_firewall_rule in Azure Managed Instance? Thanks, Abhishek Modi
asked 2024-04-22T12:26:02.4033333+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(80, 77%, 17%)' 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)
Abhishek Modi (amodi)
0
Reputation points
answered 2024-04-22T15:03:28.0966667+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, 95%, 23%)' 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)
Abhishek-MSFT
181
Reputation points Microsoft Employee
1 answer
I am using the Student version of Microsoft azure. Can I create Data lake and Data warehouse with this version?
I am student in CIT , Coimbatore.I want to explore the concepts of Data warehouse so I choosed Microsoft azure student version.Can I create warehouse in this version if not please suggest another platforms to create effective warehouses for free.
asked 2024-04-18T05:01:48.5133333+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, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Harish Kumar
0
Reputation points
edited an answer 2024-04-18T07:38:57.85+00:00
Sumarigo-MSFT
44,806
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Increasing usage of MySQL server
Hello, When I go to the Top free services by usage section in Subscriptions>Overview, I notice continuous increasing in the "Azure Database for MySQL, Flexible Server Storage, Data Stored" usage. It is increasing daily although i stopped…
asked 2024-03-30T08:53:18.47+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, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mohmmed Magdy
30
Reputation points
commented 2024-04-16T10:43:15.95+00:00
Mohmmed Magdy
30
Reputation points
1 answer
PowerBI Service connection fails to Azure Database for MySQL flexible server
Hello, I created a semantic model connected to my Azure Database for MySQL flexible server. It refreshes successfully from powerbi desktop, but once the dashboard is published, it does not refresh anymore. The error I am getting is: …
asked 2024-04-13T14:44:34.5566667+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, 67%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPY%3C/text%3E%3C/svg%3E)
Peter Yacoub
0
Reputation points
answered 2024-04-15T15:06:47.6+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
1 answer
Private link / VNet integration between App Service and MySQL Database
Hello, Between an App Service and an Azure Database for MySQL I created a Private Link with VNet integration, so that the Database for MySQL is only reachable through the App Service and not through the public internet. When looking at the App…
asked 2024-04-11T16:25:04.0466667+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(51.2, 32%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JohnC92
0
Reputation points
answered 2024-04-15T08:15:52.5433333+00:00
KapilAnanth-MSFT
38,966
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Cost anomaly mySQL 76% Memory, "Paid IO LRS IO Rate Operations" at $20/m for inactive (dev) wordpress website
For a Wordpress website in development almost inactive, the cost of the Azure Database MySQL is at IOPS CA$20/month, and it says the CPU at 7% but Memory constantly at 74% , and the bulk of the cost comes from "Paid IO LRS IO Rate…
asked 2023-10-30T09:49:55.7133333+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(217.60000000000002, 64%, 31%)' 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)
Christopher Mary
20
Reputation points
edited an answer 2024-04-15T07:14:05.8766667+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(201.6, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Peter Lekkerkerker
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Issues deleting Azure MySQL flexible server with “Updating” status
My Azure MySQL flexible server is unresponsive and shows “Updating” status, which started a day ago. It has been running for 10 months without issues. The server stopped responding with the message “Attention: MySQL Flexible Server Burstable SKU…
![](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(291.2, 22%, 38%)' 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)
2 answers
asked 2024-04-07T18:22:28.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(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anshul Salvi
0
Reputation points
answered 2024-04-08T05:36:14.94+00:00
ShaktiSingh-MSFT
14,201
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Which Database should I use for a moble app?
Which Database should I use for a moble app?. Specifically, I would also like a step-by-step tutorial for setting up this database. Since bing is a Microsoft product I thought I would give your AI co-pilot a try and ask him for advice. That might not…
asked 2024-04-02T14:15:07.71+00:00
William Thompson
80
Reputation points
commented 2024-04-03T21:04:13.0933333+00:00
Oury Ba-MSFT
17,556
Reputation points Microsoft Employee
0 answers
Connection timeouts connecting to Azure Database for MySql Flexible Server (with apparently no resource exhaustion)
We have an ASP .Net 8 Web API hosted on Azure App Service (Windows). It connects to an Azure Database for MySql Flexible Server v5.7, using Pomelo.EntityFrameworkCore.MySql 8.0.2. We are not using Private Access/VNet. It is a multi-tenant application,…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
750 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,541 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,240 questions
asked 2024-04-03T11:56:16.6833333+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, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Fabricio Rodriguez
1
Reputation point
commented 2024-04-03T17:40:55.4566667+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee
0 answers
Api Connection Timeouts intermitted using Azure App Service with a Mysql Flexible Server
We have had intermittent connection timeouts on our App Service when doing an http requests.
asked 2024-04-03T12:10:35.5+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, 5%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jose Pereira
0
Reputation points
commented 2024-04-03T17:23:04.95+00:00
GeethaThatipatri-MSFT
28,852
Reputation points Microsoft Employee