Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
731 questions
0 answers
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
0
Reputation points
commented 2024-06-04T21:35:01.1066667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
1 answer
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
0
Reputation points
commented 2024-06-04T09:21:56.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(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
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…
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
commented 2024-06-03T20:01:17.56+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
1 answer
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…
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
0
Reputation points
commented 2024-06-03T19:52:36.4066667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
3 answers
Connecting to a Azure MySQL instance from Data Factory Linked Service
I have an Azure Mysql Instance in a Virtual Network created as part of the instance setup. I want to be able to copy data to MYSQL as a Copy Data sink. When I try to set up a connection to the MySQL instance using the AutoResolveIntegrationRuntime it…
asked 2023-10-10T15:33:47.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(83.2, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENE%3C/text%3E%3C/svg%3E)
Navid Erfani-Ghadimi
0
Reputation points
commented 2024-06-03T13:57:20.13+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(16, 61%, 11%)' 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)
Sérgio Miguel R. P. da Silva
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Clarification on In-Place Migration Eligibility for Azure Database for MySQL Server
Dear Azure Support Team, I received a notification stating that our Azure Database for MySQL server is scheduled for in-place migration to Flexible Server during the maintenance window of 01/07/2024 - 02/07/2024, 23:00 - 05:00 UTC. However, our server…
asked 2024-05-28T14:05:26.17+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, 4%, 39%)' 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)
Cosmina Alexandra Jelea (RO)
165
Reputation points
accepted 2024-06-03T05:16:25.5033333+00:00
Cosmina Alexandra Jelea (RO)
165
Reputation points
1 answer
I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity, while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external table.
I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity. while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external…
asked 2024-05-29T06:41:24.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(147.20000000000002, 57.99999999999999%, 24%)' 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)
Sodhi, Harkrishan
0
Reputation points
answered 2024-05-29T12:08:13.1+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Daily dump mysql flexible servers databases to storage account blob container
Hi folks ! I have a mysql flexible database server with 2 databases, each database is about 50 Gb. The aim is to mysqldump daily and copy the dumps file to an azure storage account. I tried to achieve it by using an azure devops scheduled pipeline using…
![](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, 60%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
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-05-28T22:56:27.17+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
0
Reputation points
1 answer
Azure Database for MySQl Flexible - High CPU - No increase in workload
I have an Azure Web App that is connected to an Azure Database for MySQL Flexible server. This web app is a small data collection form that stores the collected values to a table which are later collected via am API in the web app. A cron job executes…
asked 2024-04-03T11:31:42.51+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, 87%, 10%)' 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)
Jon Bromley
10
Reputation points
commented 2024-05-27T19:36:59.5633333+00:00
Phillip Parr
0
Reputation points
1 answer
Issue with Azure mysql database for flexible server connection to azure app service. driver not found in sql server
org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [loginServlet] in context with path [/myshuttledev] threw exception [Servlet execution threw an exception] with root causejava.lang.ExceptionInInitializerError:…
asked 2024-05-20T18:55:03.8733333+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, 27%, 39%)' 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)
abhi
0
Reputation points
answered 2024-05-23T17:49:54.6166667+00:00
Oury Ba-MSFT
16,981
Reputation points Microsoft Employee
1 answer
Burstable MySQL flexible server is not accumulating credits
Hello, I have burstable MySQL flexible server, without any activity, but the credits are not accumulating and still dropping down to 0 after some time. I have Azure Database for MySQL flexible server, Standard_B1s. The database is very small (~1000 rows…
asked 2024-05-18T21:43:02.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(150.4, 1%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Thomas
0
Reputation points
commented 2024-05-21T04:24:29.4066667+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Mysql Flexible Server not restarting and now not excluding
I configured a Mysql Flexible server and after adjusting the server parameters it tried to restart and stayed in this process for 40 minutes. I gave up and am setting up a new Mysql server. The first server I ordered to delete and has been stuck in this…
asked 2024-05-20T00:13:39.26+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, 36%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alessandro Pinto
25
Reputation points
answered 2024-05-20T08:00:55.19+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Data Flow Sink - Connection string is not valid or missing Server/User/Database properties
Could you please assist here to resolve this issue below ? We are trying to read Delta table and store it as table in Azure SQL Database as using ADF Data Flow. Source Delta table via inline dataset from ADLS Gen2 its working fine and slink is getting…
asked 2024-05-13T06:36:57.6633333+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, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kashif Ahmed
40
Reputation points
accepted 2024-05-20T05:09:42.0966667+00:00
Kashif Ahmed
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Logic App - 502 Bad Gateway Azure Database MySQL Flexible Server
I have created an Azure Logic App with public access (Inboud) and VNET integration in the outbound. This is the network config: On the other hand, in the Virtual Network linked to the Logic App, there is a private Azure Database MySQL Flexible Server.…
asked 2024-05-16T06:25:55.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(25.6, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Miguel Ángel Chuecos Piera
20
Reputation points
accepted 2024-05-17T15:46:26.33+00:00
Miguel Ángel Chuecos Piera
20
Reputation points
1 answer
What's going on with the flexible mysql database ?
Hello, For several days now, I've been experiencing completely unexplained cpu load peaks on my flexible mysql server (B1MS). No metrics, no maintenance, no increase in requests or connections are to blame at this time. As proof, I've disconnected my…
asked 2024-04-09T08:30:32.0566667+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, 67%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zhaerius
5
Reputation points
commented 2024-05-15T06:35:23.5533333+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, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Craig Chandler
0
Reputation points
1 answer
i have install mysql server and workbecnh in vm . how i can access database out of network.
i have install mysql server and workbecnh in vm . how i can access database out of network
asked 2024-05-10T07:27:51.0066667+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, 23%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
vishal bhanushali
0
Reputation points
answered 2024-05-14T04:23:01.9733333+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
Unable to Modify innodb_dedicated_server variable in Azure Database for MySQL (Flexible Server) - Workarounds or Alternatives?
I'm trying to optimize performance for my Azure Database for MySQL (Flexible Server) instance. In my research, I found the innodb_dedicated_server parameter, but it's greyed out in the Azure portal, indicating it's non-modifiable,can i change this…
asked 2024-05-09T09:57:21.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(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niket Kumar Singh
210
Reputation points
commented 2024-05-13T10:31:17.81+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
1 answer
Deleted resources are getting billed
I had created mySQL database I have deleted the database as well as the resource group associated with the database some 5 - 6 months back. I still get billed for this. What should I do to stop this wrong billing?
asked 2024-05-13T05:07:16.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(316.8, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Abhijit Ghosh
0
Reputation points
edited an answer 2024-05-13T05:42:06.8233333+00:00
TP
79,571
Reputation points
1 answer
How to fix "AzureKeyVaultKeyNotFound" during deployment
I would like to deploy MySQL Database server. But during deployment I got an error like { "code": "AzureKeyVaultKeyNotFound", "message": "Could not find Azure Key Vault Key with key name 'Key…
asked 2024-05-08T20:26:11.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(291.2, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
C0nstanta
0
Reputation points
answered 2024-05-08T21:16:14.93+00:00
hossein jalilian
4,460
Reputation points