Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
0 answers
Azure Database for MySQL (Flexible server): "temporary failure in name resolution"
We connect to an instance of Azure MySQL (with HA enabled) from an AKS cluster. No custom DNS. Recently we've been frequently getting the following. (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on…
Azure Database for MySQL
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
241 questions
asked 2024-06-03T15:57:13.29+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, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gianluca Gippetto
41
Reputation points
edited the question 2024-07-03T04:21:38.7+00:00
Ryan Hill
27,031
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
High CPU usage for Azure Database for MySQL servers despite very low infrequent use
My Azure Database for MySQL server is showing high Host CPU percent despite very low infrequent load from us. We are using a Standard_B1s instance and our CPU credits keep running out. We have investigated what could be using up the CPU, but the server…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
241 questions
asked 2024-06-03T15:05: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(236.8, 18%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Suhail Chander
20
Reputation points
edited the question 2024-07-03T04:21:36.3+00:00
Ryan Hill
27,031
Reputation points Microsoft Employee
1 answer
Issue Creating Azure MySQL Database
Hello, I am encountering an issue while trying to create an Azure MySQL database for my university assignment. I have created a new resource group named "students-rg" and attempted to set up an Azure Database for MySQL server. However, I…
asked 2024-06-30T04:39:24.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(9.6, 73%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Sanjula De Alwis
0
Reputation points
commented 2024-07-02T07:48:20.9233333+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,406
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
In-place upgrade of MySQL Single Server to a Flexible Server
Hello, I have some questions related to in-place upgrade of MySQL server to a MySQL Flexible server. Server Name Retention: During the in-place upgrade of our MySQL Single Server to a Flexible Server, will the Flexible Server retain the same name as the…
asked 2024-06-05T13:54: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(188.79999999999998, 48%, 28%)' 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)
Chowdhury, Nasim (HC/SC)
20
Reputation points
commented 2024-07-02T01:57:22.43+00:00
Chowdhury, Nasim (HC/SC)
20
Reputation points
3 answers
One of the answers was accepted by the question author.
Migrate from DB2 to Azure Database for PostgreSQL/MySQL/MariaDB
Hi, Is it possible to migrate a DB2 database to Azure database for PostgreSQL/MySQL or MariaDB? Thanks for the helping and documentation to do this process. Cordially, Albeiro Jiménez López
asked 2023-11-02T16:25: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(9.6, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
Albeiro Jimenez Lopez
20
Reputation points
commented 2024-07-01T17:08:09.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(288, 48%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUP%3C/text%3E%3C/svg%3E)
Uliana Philippova
0
Reputation points
0 answers
Azure Database Migration Service deployment failure issue
Good morning, I am trying to deploy the Azure Database Migration Service resource from the portal, so that I can migrate a SQL database in IaaS to PaaS, but the deployment is still failing for the central France region, and I am fine. Resource…
asked 2024-06-26T11:23:44.3733333+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, 13%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFS%3C/text%3E%3C/svg%3E)
Fakri SLIMANE
61
Reputation points
edited a comment 2024-06-28T08:02:52.66+00:00
Fakri SLIMANE
61
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure MySQL Flexible crashing with Max Active Connections
Hello, I'm using WordPress on the App Service and whenever I reach ~54 active connections, the CPU starts to increase reaching 100% usage and the application becomes unavailable. The App Service plan does not have high consumption. WebApp = PremiumV3…
asked 2024-06-20T14:47:48.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(208, 19%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Uziel Silva
71
Reputation points
accepted 2024-06-27T11:57:40.1+00:00
Uziel Silva
71
Reputation points
1 answer
MySQL flexible server CPU credits suddenly consumed?
Hello, My Azure MySQL flexible server is configured with burstable tier. It was configured as B1ms, and a few days ago I switched to B1s. After the change, almost all CPU credits suddenly dissapeared and a few days later the server became…
asked 2024-06-15T08:19:12.4933333+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(108.80000000000001, 57.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBV%3C/text%3E%3C/svg%3E)
Bogdan Vasile
0
Reputation points
commented 2024-06-24T19:01:33.13+00:00
Oury Ba-MSFT
18,021
Reputation points Microsoft Employee
1 answer
Scheduled Migration Maintenance from Single to Flexible MySQL Server (5.7 to 8.0)
Hello, as many Microsoft customer I received the mail about the scheduled migration from Single to Flexible MySQL Server. Does the migration from a Single 5.7 do also the upgrade to MySQL 8.0 ? Best regards Roberto
asked 2024-06-06T14:22:49.22+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, 80%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM6%3C/text%3E%3C/svg%3E)
MADRetiredTiger-6530
0
Reputation points
commented 2024-06-24T16:39:13.8366667+00:00
GeethaThatipatri-MSFT
29,017
Reputation points Microsoft Employee
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,017
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
ShaktiSingh-MSFT
14,406
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,017
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,017
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,406
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,811
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,406
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,176
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