Microsoft Q&A

Azure Database for MySQL

568 questions

An Azure managed MySQL database service for app development and deployment.

Browse all Azure tags

470 questions with Azure Database for MySQL tags

Sort by: Updated
7 answers

Unable to connect to MySQL flexible server on Azure on MySQL Workbench on PC.

As the title says, I am unable to connect to the MySQL database that is hosted on Azure through the MySQL workbench app installed on my PC. I always get the error "Could connect to localhost" which is odd Like I followed all of the steps…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-01-23T19:30:35.1+00:00
Kamil Krauze (Student) 0 Reputation points
answered 2023-09-23T21:41:26.4566667+00:00
Curtis Jackson 0 Reputation points
1 answer

Connecting to App Service mySql flexible Database from outside VNet

A few months ago, when I created a "Web App + Database", I was later able to access the database in the Azure Web Console, click Networking, enable Public Access by IP, and then use mySql CLI from my computer to connect to the created…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2023-09-10T00:42:17.46+00:00
Kenny Pak 75 Reputation points
commented 2023-09-21T03:28:05.56+00:00
TP 43,906 Reputation points
1 answer

How to correctly set Connection String in Azure Web App?

Hello, I have set up an Azure Web App (App Service), which I have configured to be connected to an Azure Database for MySQL Flexible Server through VNet integration. Everything works fine, but at some moments of the day there's an issue where the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2023-09-18T10:23:09.94+00:00
Uhmazing34 20 Reputation points
commented 2023-09-20T10:28:17.3933333+00:00
Ben Gimblett 2,190 Reputation points Microsoft Employee
1 answer

cannot create azure mysql database flexible server in australia southeast region. and trying to geo restore it from australia southeast region, it is also not working,

not being able to restore geo redundant database for mysql database(ha zone redundant), primary region-australia east, secondary region- australia southeast, not being able to geo restore. also not being able to create a database in southeast australia…

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,000 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2023-09-15T19:09:41.6566667+00:00
Sucharita Chaudhury 0 Reputation points
answered 2023-09-15T20:16:53.8933333+00:00
Rahul Randive 4,366 Reputation points Microsoft Employee
1 answer

Role to explore in Azure MySQL Flexible server.

Hi, I have created an Azure web app as well as a flexible MySQL server database in the same resource group. I want to grant access to my developer for this resource group so they can work on both the web app and the MySQL database. I added the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
520 questions
asked 2023-09-13T10:37:46.08+00:00
Morsi 25 Reputation points
answered 2023-09-15T10:48:21.47+00:00
GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee
2 answers

Unable to see azure databse for mysql flexible server in azure portal

I observed i am able to connect mysql server along with all the databases. but when i try to see these resources in azure portal. i can't see it. I already performed remove filter, looking at correct resource group, subscription. can someone assist me…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-09-13T08:45:54.34+00:00
Mahesh Panchal 11 Reputation points
answered 2023-09-15T05:31:59.82+00:00
ShaktiSingh-MSFT 9,391 Reputation points Microsoft Employee
2 answers

Unable to connect to MySQL in app from ASP.NET Core Blazor app deployed in Azure app service

I have my ASP.NET Core Blazor app in Azure app service. This app uses a MySQL DB. I am trying to use MySQL in app feature in Azure app service. Below if the connection string in appsettings.json "DefaultConnection":…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,105 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2022-12-01T05:52:17.263+00:00
Sathya Narayanan 1 Reputation point
answered 2023-09-13T09:13:23.4933333+00:00
KAMBOU OLLO DIDIER 0 Reputation points
1 answer One of the answers was accepted by the question author.

The simple Join command fetching duplicates

Hi Everyone interested, iam using below Join command which is duplicating the values, where i make wrong? SELECT LeaveBalance.empid, LeaveBalance.empname,CONCAT(LeaveBalance.leavetype,' - ',(select leavetype.PayType from LeaveType where…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,943 questions
asked 2023-09-11T08:03:57.9533333+00:00
shankar naren 20 Reputation points
edited the question 2023-09-11T13:23:27.03+00:00
AjayBathini-MSFT 30 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Unable to connect to Azure Database for MySQL flexible server from MySQL Workbench

I have created a web app with a MySQL database (web app + database in Azure Marketplace), and everything is working fine. I have successfully deployed a PHP "Hello World" code. Now, I want to connect to the MySQL database using MySQL Workbench.…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-09-08T10:42:52.3066667+00:00
Morsi 25 Reputation points
accepted 2023-09-11T10:23:07.13+00:00
Morsi 25 Reputation points
1 answer

Azure MYSQL resource not showing up

For some reason my MYSQL database is not showing up on my Azure portal. When I press "All resources" (no filter is applied) nothing shows up. I am still able to connect to the DB in MySql Workbench.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2022-02-21T20:52:04.79+00:00
ffffjjjjjjaaaa 1 Reputation point
edited the question 2023-09-07T15:48:00.7833333+00:00
GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Visual Studio 2022 cannot publish an Azure SQL database project

I have created a DB project with VS2022 for an Azure SQL DB and everything works perfectly under my own credentials. I have also created a login (jdoe), a user (jdoe) under that login and I have given the db_owner role to jdoe. When using jdoe login and…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-09-05T17:26:35.7266667+00:00
Oyinkansola Shoroye 25 Reputation points
commented 2023-09-07T01:39:41.5966667+00:00
Oyinkansola Shoroye 25 Reputation points
1 answer

azure webapp creation error using free plan

{ "deploymentStatusCode": -1, "stage": 6, "expected": true, "error": { "code": "InvalidTemplateDeployment", "details": [ { "code":…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2023-09-05T13:24:49.8866667+00:00
FXBS 0 Reputation points
answered 2023-09-06T09:07:40.4833333+00:00
VenkateshDodda-MSFT 11,921 Reputation points Microsoft Employee
2 answers

Azure Database For MYSQL not appear at azure portal

It was working yesterday, I did not change anything but database has been gone for no reason. I can not see azure database for mysql service at my azure portal. It appears in billing section to show the cost but nowhere else .

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-08-17T11:41:58.1766667+00:00
onur.gokce 5 Reputation points
commented 2023-09-06T04:11:26.07+00:00
ShaktiSingh-MSFT 9,391 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Mysql Flexible Server Query Cache

After I updated the procedure, I found the procedure output variable result for the same input variables did not get updated. I am wondering how to clear query cache for mysql stored procedure. Does execution plan cache gets cleared everytime the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-08-24T15:43:00.7566667+00:00
Yanping Sun 40 Reputation points
accepted 2023-09-05T21:50:20.2433333+00:00
Yanping Sun 40 Reputation points
1 answer

what are the exact limits on the azure subscription with free credit?

in some of the tests of my deployed application on azure, even when I scale up the performance stays the same. I wonder if there are any specific limits on the account while using the free credit?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,621 questions
asked 2023-08-05T05:44:46.15+00:00
Amir 0 Reputation points
edited the question 2023-09-04T13:27:18.2966667+00:00
Sumarigo-MSFT 38,811 Reputation points Microsoft Employee
1 answer

Getting Server Error - There was an unexpected error in the request processing azure

I started getting " Server Error - There was an unexpected error in the request processing azure" randomly in azure function apps after Aug 22, 2023. I am unable to see any description of these errors in logs. My scenario is : Load is…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,436 questions
Azure Traffic Manager
Azure Traffic Manager
An Azure service that is used to route incoming network traffic for high performance and availability.
97 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-08-31T09:31:27.61+00:00
Gurpreet Singh 0 Reputation points
commented 2023-09-04T04:27:56.5433333+00:00
navba-MSFT 4,605 Reputation points Microsoft Employee
1 answer

query to databricks cluster using postman

Hi Expert, can you help me with hostend point to URL to call Databricks compute cluster I used PAT and below URL but not working ad.azuredatabricks.net/api/2.0/clusters/pat_token

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,127 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,540 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,597 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,000 questions
asked 2023-08-14T13:30:43.0233333+00:00
Shambhu Rai 996 Reputation points
commented 2023-09-01T05:15:03.9733333+00:00
KranthiPakala-MSFT 43,422 Reputation points Microsoft Employee
2 answers

How to fix MySql Flexible Server- The server is currently in updating state. Please wait for the operation to complete.

Hi. MySql Flexible server is stuck in an updating state for over an hour. i have tried to stop and restart via Azure CLI and still not successful. any suggestions?

Azure Cloud Services
Azure Cloud Services
An Azure platform as a service offer that is used to deploy web and cloud applications.
554 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.
555 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2023-08-10T21:20:35.0333333+00:00
Tawfeeq Jamal 0 Reputation points
edited the question 2023-08-31T14:20:52.1333333+00:00
GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee
1 answer

Compute cluster access to warehouse cluster query

Hi Expert , How compute cluster will have access to warehouse sql cluster to run sql query or atleast it should link database to both the cluster as database should access from both the clusters

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,127 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,540 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,597 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,000 questions
asked 2023-08-15T18:34:30.83+00:00
Shambhu Rai 996 Reputation points
commented 2023-08-22T08:40:27.9+00:00
PRADEEPCHEEKATLA-MSFT 65,986 Reputation points Microsoft Employee
1 answer

Creation of New Flex MYSql Server with HA enabled for UK South Keeps Failing

Also, we have a production level MySQL Flex server, sat in UK South, that won't allow us to turn on HA as well

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
568 questions
asked 2022-08-25T15:46:19.503+00:00
Ben Laycock 1 Reputation point
edited the question 2023-08-21T15:01:53.8666667+00:00
GeethaThatipatri-MSFT 21,396 Reputation points Microsoft Employee