Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
1 answer
Azure mysql Enterprise to community
Whenever if there are user using mysql enterprise version on premiss, is it possible to migrate to azure mysql, coz mysql azure is running cummunity version . and what's the support for Azure mysql community version ?
asked 2020-12-30T10:28:23.447+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, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
answered 2021-01-04T04:58:47.44+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, 10%, 12%)' 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)
KalyanChanumolu-MSFT
8,316
Reputation points
1 answer
Register Service Principal for MySQL server
Hi, I am trying to set up data encryption for our Azure Database for MySQL server as per this link https://video2.skills-academy.com/en-us/azure/mysql/howto-data-encryption-portal I have created the Key Vault. While adding access policy to the…
asked 2020-11-10T10:59:48.763+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(185.6, 70%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Ravindra Pawar
21
Reputation points
commented 2021-01-04T04:05:28.157+00:00
Ravindra Pawar
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure database for my sql .
My I know when i provision a mysql single server . the Mysql instance is shared with the other mysql instance from the other customer for that single server ?? or this single server really serve only ONE mysql instance ?
2 answers
Connect to Basic Mysql from AKS Nodejs Pod
I have defined an external Service in AKS as below apiVersion: v1 kind: Service metadata: name: mysql namespace: mySpace spec: type: ExternalName externalName: myDb.mysql.database.azure.com then in my node app attempt to access by …
asked 2020-12-03T14:29:26.623+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(124.80000000000001, 8%, 22%)' 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)
James Bissett
1
Reputation point
commented 2020-12-10T07:06:37.333+00:00
James Bissett
1
Reputation point
0 answers
Becoming really frustrated with Azure / MySQL and Azure API / Python - cannot connect reliably
Hello, I am becoming more and more frustrated with trying to do what I think is a simple task: I have created a MySQL database on Azure. I have deployed a web API through Azure - it builds and launches, but of course is throwing 500's I…
asked 2020-11-22T01:38:34.933+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(272, 7.000000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Scott Fergusson
1
Reputation point
commented 2020-11-30T22:11:47.837+00:00
Ryan Hill
26,866
Reputation points Microsoft Employee
1 answer
Connecting web app to mysql database
Hello, is it possible to connect an azure web app to an azure mysql database that is hosted on Azure Express (hybrid) ? because I see that the only possibility to do that is to get an Azure SQL database and not MySQL database
asked 2020-05-04T22:12:22.81+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, 90%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZS%3C/text%3E%3C/svg%3E)
ZOUAOUI Sarra
11
Reputation points
commented 2020-11-17T10:05:28.227+00:00
EnterpriseArchitect
5,036
Reputation points
2 answers
Need to configure WSUS server with SQL PaaS database in azure
Need to configure WSUS server with SQL PaaS database in azure. Is it possible to do with Azure PaaS DB. Please help me on this. Thanks in advance.
asked 2020-11-12T05:42:52.443+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, 16%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Praveen Mittapalli
36
Reputation points
commented 2020-11-13T02:57:11.947+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(297.6, 24%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Rita Hu -MSFT
9,626
Reputation points
1 answer
One of the answers was accepted by the question author.
InApp Mysql VS Azure Database for MySQL Which one is faster for Woocommerce Wordpress website ?
Currently, I have a Woocommerce Wordpress website ( https://accentthaikitchen.com ) It is currently super slow. I am using the Azure Standart Plan 2. But I am suspecting that it is slow because I am using the InApp Mysql. Would using Azure…
asked 2020-11-07T07:01:21.49+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(275.2, 67%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
savemightlife
21
Reputation points
accepted 2020-11-10T06:11:34.417+00:00
savemightlife
21
Reputation points
1 answer
DB import error
Hi, I created a MariaDB server and I am able to connect it using commandline. I created a database and few empty tables from mysql cli without any issues. I am unable to import a database dump in the server. I get below error, root@Anonymous [~]# mysql…
asked 2020-08-21T12:26:41.07+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, 26%, 21%)' 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)
Ajin Prasad
6
Reputation points
answered 2020-10-28T19:55:25.18+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, 25%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Miroslav Adamec
1
Reputation point
1 answer
One of the answers was accepted by the question author.
@@global.autocommit=1 @@session.autocommit becomes 0 Why?
Dear Azure support. We have an Azure database for MySQL instance that is running MySQL engine version 5.7. It has the @@Anonymous .autocommit set to 1. When a fresh connection (with no connection parameter nor initSQL) is established,…
asked 2020-10-22T05:49:43.89+00:00
Shintaro Sasaki
96
Reputation points
accepted 2020-10-23T16:35:09.203+00:00
Shintaro Sasaki
96
Reputation points
2 answers
One of the answers was accepted by the question author.
SQLQuery Help
Hi! Can anyone help me with the query to get this information from the database on the URL bellow? Names of customers and the items they bought whose price is less than 600. City of the client and name of the article of all the orders that were…
asked 2020-10-11T00:51:16.73+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, 81%, 24%)' 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)
juannntrujillo
21
Reputation points
commented 2020-10-12T12:24:03.883+00:00
juannntrujillo
21
Reputation points
2 answers
Convert Azure MySQL database into a Azure SQL Server database
There are a few guides on how to migrate a MySql database to Azure SQL Server - on premise - but I was thinking there may be a more automated way to achieve converting an Azure MySql instance into an Azure SQL Server. Does anyone have any…
asked 2020-10-01T10:59:09.563+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(144, 55.00000000000001%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIK%3C/text%3E%3C/svg%3E)
i.klek
1
Reputation point
answered 2020-10-09T06:57:39.18+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, 64%, 20%)' 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)
Aleck Stewart
1
Reputation point
1 answer
Azure MySQL AAD group member not logged as external_user_s
As a follow-up from AAD group member not logged as external_user_s: As outlined in Azure MySQL Audit Logs and Azure AD Authentication Learnings, it should be possible to log the individual user if that user logged in with the AAD group name and the…
asked 2020-10-01T07:47:37.9+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, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES0%3C/text%3E%3C/svg%3E)
SchefflerFelix-0906
1
Reputation point
commented 2020-10-09T04:15:39.62+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(297.6, 97%, 38%)' 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)
Anurag Sharma
17,586
Reputation points
1 answer
MySQL for Azure connection reset by peer - unpredictable errors in Python code
I have a python application connecting to our Azure MySQL database. It parses through a large CSV of items, hits an external API for data, and then posts that data to the db. In the loop, I do a couple of SELECT queries that are parameter driven, an…
asked 2020-10-06T20:14:45.33+00:00
Scott Fergusson
1
Reputation point
commented 2020-10-08T22:50:41.61+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Connection reset by peer - MySQL and Python
Hello - I am building an application that: Parses a CSV with item numbers. Hits our Azure mySQL to see if the item exists If it does, it goes to the next item If it doesn't, it adds the item to the database. The CSV has thousands of…
asked 2020-09-28T18:00:31.027+00:00
Scott Fergusson
1
Reputation point
commented 2020-10-01T11:37:01.933+00:00
Scott Fergusson
1
Reputation point
1 answer
Database Firewall Settings
I am attempting to configure MySql firewall for container instances. I have successfully parsed the output from the CLI to get the new public ip address of the container instance, however, it does not seem to use that ip address to connect to the…
asked 2020-09-23T15:48:23.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(211.20000000000002, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kevin
1
Reputation point
commented 2020-09-28T18:05:47.123+00:00
Mike Ubezzi
2,776
Reputation points
1 answer
Alternate solution for select ... into outfile in Azure database for MySQL?
We have a requirement, capture query output to output file like as below in Azure MySQL. The below query is possible in on-prem MySQL server. But we need the same in cloud PAAS solution or alternative method to achieve it SELECT COUNT(*) FROM…
asked 2020-09-14T16:54:06.003+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, 17%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kishore Chilaparapu
1
Reputation point
commented 2020-09-17T04:55:49.827+00:00
Mike Ubezzi
2,776
Reputation points
0 answers
Data in replication to Azure Mysql is not working
Today I've tried to setup data in replication from dedicated Mysql 5.7 (Percona xtradb 5.7) server in to "Azure Database for MySQL server" Completed all steps in the guide:…
asked 2020-09-08T10:09:20.897+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(128, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPG%3C/text%3E%3C/svg%3E)
Pavel G
1
Reputation point
commented 2020-09-14T17:30:20.367+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(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,221
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure CLI command to enable Advanced Threat Protection and Data encryption in MySQL servers
I am trying to enable "Advanced Threat Protection" and "Data encryption" features for MySQL databases. I found the tutorials for enabling the features in the Azure portal, but I didn't find any documentations for Azure CLI. According…
![](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, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
0 answers
Can I use log4jdbc?
spring.datasource.driverClassName=net.sf.log4jdbc.sql.jdbcapi.DriverSpy I couldn't use this. I am using azure mysql. I tried to print a log using log4jdbc, but the database connection is not possible. Can I use log4jdbc other than the…
asked 2020-08-26T11:13:27.017+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, 18%, 31%)' 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)
seunghee cho
1
Reputation point
commented 2020-09-02T01:15:42.02+00:00
Navtej Singh Saini
4,221
Reputation points Microsoft Employee