Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
1 answer
One of the answers was accepted by the question author.
Unable to create mysql database
Hello All. I am trying to create the database for mysql and not able to do so. Backstory: I created the database initially; however, I deleted it because I was entering information for the creation of the PostgreSQL database. I am working under the…
Azure Database for MySQL
asked 2021-12-07T03:17:48.997+00:00
Vonosia Caldwell
21
Reputation points
accepted 2021-12-10T03:00:12.777+00:00
Vonosia Caldwell
21
Reputation points
1 answer
How to disable 'only_full_group_by' mode
I am actually studying mysql, the mysql running locally can turn off 'only_full_group_by' mode with commands below, how can I turn this mode off on Azure? the same command return that I need root to do this. MySQL [(none)]> set @@Anonymous …
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-11-16T04:59:33.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(64, 30%, 16%)' 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)
玉琦
1
Reputation point
commented 2021-12-08T01:04:36.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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,851
Reputation points Microsoft Employee
Moderator
1 answer
How to connect to Azure MySQL Database on local machine with private access
Hi, I recently created an Azure MySQL Database with private access, because I need to connect to it remotely through a VPN without adding Firewall rules every time. I'm stuck on how to connect to it on my local Windows computer for development…
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,796 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-12-03T22:16:10.31+00:00
Winston Zhao
1
Reputation point
answered 2021-12-04T09:38:49.203+00:00
msrini-MSFT
9,291
Reputation points Microsoft Employee
1 answer
How to intersect and find closest point on multilineString from a point in Mysql and C#
I want to find out the nearest point on my road network by intersecting which is a multiline string from a point geometry (bus stops) with latitude longitude value. 1)my bus stop point is => POINT (2.155033 41.419847) 2)my bus route line is => …
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Developer technologies | C#
11,579 questions
asked 2021-12-01T12:22:25.4+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, 79%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Ishwar Giri
1
Reputation point
commented 2021-12-02T05:39:03.6+00:00
Ishwar Giri
1
Reputation point
2 answers
One of the answers was accepted by the question author.
mysql on version 5.7 but hecking the server status states Server version is 5.6.42.0
We have a setup for azure mysql on version 5.7 according to the azure portal, however checking the server status states Server version is 5.6.42.0 MySQL Community Server (GPL). See attached.
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
64 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2020-05-14T02:08:30.073+00:00
Rohan Jones
291
Reputation points
commented 2021-12-01T16:33:31.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(28.799999999999997, 35%, 12%)' 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)
Venu Gopal
1
Reputation point
1 answer
Azure SQL managed Instance Link Mysql as linked server
Hi community, in our company we have a situation. We have a SQL Managed Instance and an Azure MySQL Database. And we need to link these DBs. Is there a way to add a Mysql database as Linked server for a SQL Managed Instance, or this need to be…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
SQL Server | Other
14,501 questions
asked 2021-11-18T13:38:31.89+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, 7.000000000000001%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Juan Martin Peralta
1
Reputation point
commented 2021-11-29T23:48:02.173+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
MySQL in APP version update
Currently, the only version which is available for MySQL in APP is 5.7.9 - MySQL Community Server (GPL). How can I update the version to 8.0.26?
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-11-11T12:18:22.493+00:00
Vladislav Antonyuk
1
Reputation point MVP
answered 2021-11-29T22:53:04.313+00:00
Saurabh Sharma
23,851
Reputation points Microsoft Employee
Moderator
1 answer
One of the answers was accepted by the question author.
SSL for Java Web App Connection to Azure mySQL
I'm interested in setting up an Azure Web App that connects to an instance of "Azure Database for MySQL server" and I have a few questions that the Documentation isn't answering (or I just haven't found the documentation that does). I'm…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,970 questions
asked 2021-11-14T22:09:52.64+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(300.8, 84%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
John Jacko
21
Reputation points
commented 2021-11-27T19:30:50.477+00:00
John Jacko
21
Reputation points
3 answers
One of the answers was accepted by the question author.
Resource parameters not loading (error 500) - Azure DB for MySQL
Tried in every browser. When i access /resource/subscriptions over Azure Portal (Azure Database for MySQL Flexible Server), gives me "no results". On console, i can see the following error: R3IAwc0JygC1.js:10 [Microsoft_Azure_OSSDatabases] …
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-06-05T13:51:55.897+00:00
Luiz Otávio Tinoco
96
Reputation points
answered 2021-11-25T12:09:09.937+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, 61%, 38%)' 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)
JuanAnD
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Auto stop/start Azure database for MySQL Flexible server
Hi all, I want to use Azure Automation for auto Stop and Start Azure Database for MySQL Flexible Server , I follow this article Auto Stop and Start your Azure Database for MySQL Single Server using PowerShell runbook It works fine with Azure…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
1,368 questions
asked 2021-11-22T01:34:18.577+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, 21%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jack Chuong
861
Reputation points
commented 2021-11-22T09:31:59.217+00:00
tbgangav-MSFT
10,426
Reputation points
Moderator
1 answer
Multiple Excels in a Sharepoint as data origin for mySQL server in Azure Data Studio
Hi, I have a Sharepoint with Excels with information from our workers, every worker has a copy of that same file with their name. I'd need to automatize something to grab all those excels into one big mySQL database, how can i create a connection…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Microsoft 365 and Office | SharePoint | For business | Windows
11,709 questions
Microsoft 365 and Office | Excel | For business | Windows
3,941 questions
asked 2021-11-16T15:50:27.69+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, 20%, 12%)' 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)
Ruiz-Ramis Joan
1
Reputation point
commented 2021-11-22T09:06:17.667+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, 1%, 13%)' 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)
CaseyYang-MSFT
10,461
Reputation points
2 answers
Link between the Local Gateway in Azure and Local Gateway in PowerBi
Hello, I'm looking to understand (and maybe to Know how to use it) the Local Gateway in Azure and local Gateway in Powerbi. Here is my use case : My PowerBi dataflow is connected to MySQL database and it seems I need a Gateway. I have tested (and…
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,557 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
![](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, 70%, 15%)' 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)
2 answers
One of the answers was accepted by the question author.
Test connection for linked service error: connection timed out
Hi All I am new to Azure and am trying to set up a connection between my Wordpress MySQL DB which is stored in google cloud and my new Azure SQL Server which I just created. Using Data Factory I am attempting to configure a linked service with the…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,651 questions
asked 2021-09-03T11:30:55.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(28.799999999999997, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mark
101
Reputation points
commented 2021-11-22T07:51:47.207+00:00
PRADEEPCHEEKATLA
90,651
Reputation points
Moderator
0 answers
MySQL server point-in-time backup restores current data
From the Azure Portal, when I do a point-in-time restoration of a MySQL server, it doesn't seem to restore the date/time that I choose. It basically just duplicates my current database server. The data and schema is not from the desired date. I've…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
![](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, 3%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECJ%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Can't understand erros, that compiler print
I don't understand errors, that compiler print . Can someone explain what the compiler expects from me ? full code : BEGIN TRANSACTION; CREATE TABLE 'CompileBatch ' ( 'BATCHID ' INTEGER, 'Yellow' INTEGER, 'Blue' INTEGER, 'Red' …
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
SQL Server | Other
14,501 questions
![](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, 76%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to do minus in ssis precedent constraint expression
I have a requirement and I'm getting PTC time through below code from SQL to get that Select right(getutcdate()-'08:00',6) and I'm getting this right in SQL but How to use the same thing in SSIS. What are the adjustments I need to make here ? Can…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
Developer technologies | Transact-SQL
4,707 questions
SQL Server | Other
14,501 questions
asked 2021-11-09T13:25:06.69+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, 8%, 22%)' 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)
Anonymous
commented 2021-11-10T09:53:19.727+00:00
Anonymous
1 answer
Azure Advisor Overprovisioned Databases recommendation
I am trying to find Azure Overprovisioned databases as mentioned in this url: https://learn.microsoft.com/en-us/azure/advisor/advisor-cost-recommendations It seems Azure Advisor will generate recommendations for "MariaDB, MySQL, and PostgreSQL…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
6,345 questions
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
3,615 questions
Azure AI Metrics Advisor
Azure AI Metrics Advisor
An Azure artificial intelligence analytics service that proactively monitors metrics and diagnoses issues.
84 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
Azure Database for PostgreSQL
Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,437 questions
asked 2021-11-02T05:57:55.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(297.6, 70%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vikas Neekhra
6
Reputation points
commented 2021-11-03T10:51:18.813+00:00
Vikas Neekhra
6
Reputation points
0 answers
Can't connect to MySQL database using a specific user - Servername resolved to an unknow IP address
Hi, I have the same issue here and don't know how to do. I use the service Azure Database for MySQL server. My database is only on a private network. I created a user and when I try to connect with it using the format username@servername,…
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-10-18T13:38:02.483+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(243.2, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
David AMADOU
1
Reputation point
commented 2021-11-01T18:35:49.16+00:00
Saurabh Sharma
23,851
Reputation points Microsoft Employee
Moderator
0 answers
MySQK Workbench is not working
I couldnt connect the Azure MYSQL Database using MySQL Workbench. Connection is not establishing after much more tries.
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-10-27T13:34:46.487+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, 8%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKR%3C/text%3E%3C/svg%3E)
Kiruthika R
1
Reputation point
commented 2021-10-29T17:54:57.397+00:00
Oury Ba-MSFT
20,931
Reputation points Microsoft Employee
Moderator
1 answer
Want to filter tables coming from the Mysql database using ADF
Hi, I have 511 tables in MySql database. I want to import only 15 tables in Azure using ADF. Please tell me the way to do that.
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
996 questions
asked 2021-10-26T08:20:08.27+00:00
Amar Agnihotri
926
Reputation points
answered 2021-10-28T01:47:57.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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,491
Reputation points Microsoft Employee
Moderator