Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 questions
4 answers
MySQL Flexible Server deployment fails
Hello, I am using MySQL Flexible Server as our main DB in our project. And sometimes I have to scale it, but it fails in ~30% cases. There is one of failed message: And also code that running in Azure Portal (I am doing all of it only in…
asked 2022-05-19T05:56:36.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(220.8, 90%, 31%)' 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)
Edu Con
11
Reputation points
commented 2024-02-24T08:55:10.96+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, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kerry Kerschbaumer
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Questions about Web Application Migration
Hello, Our company is currently hosting our web-app on LAMP servers in DigitalOcean. We have three separate LAMP servers in our cloud environment: DEVELOPMENT STAGING PRODUCTION We are in the early stages of assessing our application's…
asked 2020-11-02T16:26:44.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(115.19999999999999, 18%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERZ%3C/text%3E%3C/svg%3E)
Rot Zieg
21
Reputation points
answered 2024-02-23T05:42:09.3233333+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, 85%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajnish Kumar
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Hello Team, trying to install Wordpress on AKS using the info at https://learn.microsoft.com/en-us/azure/linux-workloads/createwordpressdeployment/readme
Hello Team, trying to install WordPress on AKS using the info at https://learn.microsoft.com/en-us/azure/linux-workloads/createwordpressdeployment/readme When doing this, trying to create MySQL Flexible server fails saying SKU is not available... Is…
asked 2024-02-21T21:57:14.6266667+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, 2%, 31%)' 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)
Pandu Pabbisetty
20
Reputation points
commented 2024-02-23T04:23:59.66+00:00
Prrudram-MSFT
22,396
Reputation points
1 answer
Connect to Azure Database for MySql from SSIS failed with error
Hi, I am trying to connect to Azure Database for Mysql from SSIS. I have installed the connector (MySql connector for NET ADO) I have entered the server name, username (MySql database username) and password and the port 3306. When I clicked Test…
asked 2024-02-21T15:59:47.2933333+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(38.4, 96%, 13%)' 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)
Raj Maddala
20
Reputation points
commented 2024-02-22T17:05:58.12+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
2 answers
My databases does not show in the MySQL Flexible Server.
I have web app created using app service and that connects to the Azure Database for MySQL flexible server with compute tier Burstable, B1ms, 1 vCores, 2 GiB RAM, 32 GiB storage. It was working fine but suddenly I was not able to login through my web…
asked 2024-02-21T22:26:03.0533333+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, 34%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Parbata Bastola
0
Reputation points
commented 2024-02-22T17:02:14.0133333+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to make encrypted connections mandatory on Azure MySQL flexible server
I want to make sure all client connections to Azure MySQL flexible server are encrypted. or I want to reject all unencrypted connections to MySQLDB. Turning on server parameter "require_secure_transport" is not helping. I am still able to…
asked 2024-02-21T13:32:37.9533333+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
accepted 2024-02-22T12:58:28.12+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
1 answer
Securely connect to Azure SQL DB from Desktop (WinForms) app
I'm developing an desktop app (WinForms C#) for use in an office environment that will generally interact with a database hosted on the office's local network. However, I'd like to provide the option of a cloud-hosted database. Azure SQL Database or…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,176 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
983 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
719 questions
asked 2024-02-20T14:54:44.68+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, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Derek R
0
Reputation points
answered 2024-02-20T23:39:16.59+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
How to connect Azure database to Wix
Hi, I'm doing a project connecting the Azure database to the Wix platform. I followed the instructions from the Wix website, but there were missing details, so I struggled to test the API phase. The suggested testing API is deployed by using Curl. From…
asked 2024-02-14T01:49:37.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(262.40000000000003, 8%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrew Haning
5
Reputation points
commented 2024-02-20T03:25:07.1266667+00:00
Andrew Haning
5
Reputation points
1 answer
One of the answers was accepted by the question author.
How to connect to Vnet integrated MySQL Flexible Server from AI Search
I'm using a MySQL Flexible Server as data source for an Indexer in my AI Search Service. Everything worked smoothly when all the resources were public but I'm having trouble getting it to work in a private environment. The DB is in a protected Vnet. The…
asked 2024-02-14T13:42:21.0533333+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, 78%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHJ%3C/text%3E%3C/svg%3E)
Haani Jessin
20
Reputation points
accepted 2024-02-19T11:32:02.5166667+00:00
Haani Jessin
20
Reputation points
1 answer
Not able to create MySQL flexible Server Replica in paired region
When we are trying to create read replica for MySQL flexible Server through AZ CLI/terraform, it's throwing internal server error. although if we are trying from the Azure portal then it's working fine. Please find the below details of error: …
asked 2024-02-15T10:35:14.31+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(284.8, 71%, 37%)' 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)
Maulin Shah (Crest Data Systems Private Lim)
40
Reputation points Microsoft Vendor
commented 2024-02-19T03:53:46.1266667+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
1 answer
create a SQL job
How do I create a SQL job to remove logs from a database periodically
asked 2024-02-14T10:53:25.19+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(265.6, 48%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYI%3C/text%3E%3C/svg%3E)
Yeboah, Isabella
0
Reputation points
commented 2024-02-16T04:16:18.1166667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Can Azure Data Factory connect to Azure MySql Flexible via private endpoints?
I have an Azure MySql Flexible instance, and an Azure Data Factory instance. Both resources are in the same subscription, connected to private endpoint on the same vnet (each in it's own /29 subnet). On my Data Factory instance, I followed the steps…
asked 2022-04-08T12:58:54.11+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, 89%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EJ Marmonti
141
Reputation points
edited a comment 2024-02-14T13:38:50.6233333+00:00
Haani Jessin
20
Reputation points
1 answer
How to reset Password for 'root' account in phpmyadmin - running on a VM
I am running a VM and it is running mysql Address: 23.101.232.74 Name of the VM: vm-kmdesktop-db I have forgotten the root password and need to reset it Phillip Hamilton Kindy Manager
asked 2024-02-10T04:09:51.66+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-02-14T02:23:28.9833333+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
23,651
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Update MySQL Server Create Failed on Azure database for MySQL
I'm trying to create a MySQL server with Azure Database for MySQL functionality. My account is new and I'm still on the free version. I'm trying to do this through the browser. I have tried more than six times, and it always returns the following…
asked 2024-02-13T03:14:13.2633333+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, 66%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dario Gutierrez Rodriguez
20
Reputation points
answered 2024-02-13T05:41:12.7833333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
ERROR 2013: Lost connection to MySQL server during query
I am able to run select and create statements. but facing below error only when I try to run an ALTER command. increased connection timeout values, no luck. Operation failed: There was an error while applying the SQL script to the database. ERROR 2013:…
asked 2024-02-05T12:56:46.8733333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
accepted 2024-02-13T05:16:31.84+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
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-02-12T22:18:56.0266667+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
"What could be causing the 'Error: connect EACCES ::1:3306' when executing the line 'const connection = await mysql.createConnection' in my Node.js function within Azure Function App? I've verified that the credentials for the MySQL connection and token a
Q)The Below is my node js function using azure function app .But when the line “const connection =await mysql.createConnection” starts executing i am getting an Error mentioned below “Error: connect EACCES ::1:3306 at Object.createConnection…
asked 2024-02-07T03:53:38.1766667+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, 85%, 35%)' 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)
Ajal Jose
0
Reputation points
answered 2024-02-12T06:08:53.4866667+00:00
MayankBargali-MSFT
68,746
Reputation points
1 answer
One of the answers was accepted by the question author.
Development and Production Slots for Azure MySql Server
I am wondering if there are any provisions to swap database server from development to production slots, similar to 'deployment slots' provided for Azure App Service? What are the recommended guidelines for migrating Azure Database for Mysql from…
asked 2024-02-09T14:47:52.0866667+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, 33%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUR%3C/text%3E%3C/svg%3E)
Umer Rashid
85
Reputation points
accepted 2024-02-11T20:15:00.9933333+00:00
Umer Rashid
85
Reputation points
1 answer
Huge storage increase when executing alter table command in azure managed instance database
We are currently using an Azure managed instance to fulfill our data storage requirements. This instance has a database named ISMCRMMirror, housing approximately 24 million records. A recurring aspect of our operations involves the biweekly addition of a…
asked 2024-02-06T08:39:40.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(12.8, 92%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELP%3C/text%3E%3C/svg%3E)
Lalantha Perera
5
Reputation points
commented 2024-02-09T10:45:49.3466667+00:00
Lalantha Perera
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure service relocation
Hello everyone! I was wondering if someone could provide some help or guidance with our current situation: Early this month we decided to part ways with our current Microsoft partner that provides Azure-related services on top of some staffing for us.…
asked 2024-02-08T18:27:39.63+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, 35%, 19%)' 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)
Brayan Mora
20
Reputation points
accepted 2024-02-08T20:45:43.62+00:00
Brayan Mora
20
Reputation points