765 questions with Azure Database for MySQL tags

Sort by: Updated
0 answers

How to connect and query with MySQL server using Azure Machine Learning

Hi, I am currently working on a project where I need to connect to an Azure Database for MySQL using Azure Machine Learning (AML) and Python scripts. However, I want to use AML resources such as Datastore and Dataset for the connection rather than…

Azure Machine Learning
Azure Machine Learning
An Azure machine learning service for building and deploying models.
2,724 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,936 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,180 questions
Azure Database for PostgreSQL
asked 2024-07-23T07:30:11.6466667+00:00
Tú Nguyễn 85 Reputation points
commented 2024-07-24T12:50:04.6666667+00:00
dupammi 8,035 Reputation points Microsoft Vendor
1 answer

Point In Time Restore fails

I'm trying to deploy an Azure Database for MySQL flexible server from Point In Time backup source and it always fails with "Conflict" status. I've tried different server sizes (more vCPUs) and different backup points (different hour/days) and…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-22T00:34:51.7633333+00:00
Nakazawa 0 Reputation points
commented 2024-07-24T08:40:05.2666667+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
1 answer

Why can't I create a MySQL server?

I have tried choosing different regions but the deployment keeps failing, and the error messages are all generic and unhelpful. It just says there is some kind of internal server error in the deployment's related event logs. An unexpected error occured…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-22T20:34:07.7166667+00:00
DGPW 0 Reputation points
commented 2024-07-22T22:48:54.6233333+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How will Microsoft handle reports of "MySQL 8.0.38, 8.4.1 and 9.0.0 crashes on restart if database has 10K tables or more"

My team is currently using Azure Database for MySQL Flexible Server and I've seen recent posts from Percona that there is is an unstable fix release 8.0.38 which is only a few fix release levels from our current environment. See: …

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-17T18:22:01.78+00:00
Pat Weisman 20 Reputation points
accepted 2024-07-22T15:02:17.8366667+00:00
Pat Weisman 20 Reputation points
2 answers

in pass few days, all the metrics of Azure Database for MySQL flexible server is missing

Hi all, I have two running over two year Azure Database for MySQL flexible server, they are missing the metrics data since 5 days and 7days ago. All the metrics data is missing, I can not see any default monitoring metrics data, just like the CPU…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-15T02:47:12.4066667+00:00
Stephen Wong 10 Reputation points
edited a comment 2024-07-17T23:49:48.86+00:00
Angel Mae Vertudazo 0 Reputation points
1 answer

Azure MySql Database to power apps

Dear Azure Expert, I am new in Azure , I want to create table directly to Azure MySQL without using MySQL work bench, is it necessary? btw Im using powerapps I really want to migrate all my data from SP list to Azure, is there other way? Recommended…

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-16T12:30:06.8966667+00:00
Mon-Mon 0 Reputation points
commented 2024-07-17T18:20:34.63+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
0 answers

Is Azure Support Always This Ineffective?

We've experienced an extremely frustrating situation with Azure Support and would like to know if others have faced similar issues. Here's a brief summary of our ordeal: 1. Production Downtime: On June 18th, we discovered that our CRM was down.…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-03T15:09:20.5366667+00:00
Alberto B 0 Reputation points
commented 2024-07-17T14:55:51.5+00:00
Alberto B 0 Reputation points
2 answers

MYSQL restore DB

while restoring my DB using MYSQL workbench it creates my_row_number on the tables with AI PK, I need to stop the auto creation since causing issues in my API. If I restore the DB locally works fine only while restoring it on azure

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-06-27T08:29:01.1166667+00:00
Ali Jabak 0 Reputation points
commented 2024-07-16T23:34:21.4266667+00:00
GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
0 answers

Major version upgrade to MySQL 8.0 from 5.7: Fails validation process with error "Usage of removed functions" but it doesn't show any detail on what functions are failing.

I am trying to upgrade my Azure MySQL from 5.7 to 8.0 version. I am following the current guide: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade The problem is that it doesn't specify which functions are failing or the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-06-27T11:26:24.4133333+00:00
Binal Kagathara (Crest Data Systems Private Lim) 0 Reputation points Microsoft Vendor
commented 2024-07-16T20:09:12.73+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure Database Access from A Different Virtual Network

Dear Azure Team, I have an azure managed mysql database in virtual network vnet1 and a virtual machine in vnet2. I am unable to get this VM to access the database. I have a hub-spoke architecture with both vnet1 and vnet2 peered with my hub-vnet with…

Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
612 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,298 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-01T07:47:35.6233333+00:00
Seun Ore 80 Reputation points
accepted 2024-07-16T15:05:38.8266667+00:00
Seun Ore 80 Reputation points
2 answers

Azure MySQL single server got auto migrated to flexible server

I have an Azure MySQL single server which got auto migrated to flexible server and currently in stopped state because of which I can't change any settings or can't access it from any client application, when opening in azure portal its showing message…

Azure Database Migration service
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2023-09-05T06:30:44.19+00:00
Rakesh Dakornarayan Chandra 5 Reputation points
edited a comment 2024-07-16T07:24:51.1733333+00:00
Reeve 0 Reputation points
2 answers

Azure mysql flexible server data-out Migration

'Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction ''ANONYMOUS'' at source log mysql-bin.000807, end_log_pos 34861197. See error log and/or…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-09T12:38:19.1333333+00:00
Ijaz Muhammad 81 Reputation points
edited an answer 2024-07-12T05:05:45.5366667+00:00
Ijaz Muhammad 81 Reputation points
1 answer One of the answers was accepted by the question author.

create the dateid table in sql server

Hi , how to populate the dateid and date in dimtime table using script as below output upto 2029 excluding saturday and sunday create table table (dateid int,day varchar(23), dateid | day 20240601 | 2024 June 01 20290601 | 2029 June…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,076 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 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.
13,346 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,875 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
asked 2024-07-10T14:38:36.3933333+00:00
Vineet S 425 Reputation points
accepted 2024-07-10T18:52:57.11+00:00
Vineet S 425 Reputation points
3 answers

Connecting to MySQL Flexible Server in Azure suddenly failing

I have a MySQL instance in Azure which has run fine for about 2+ years. I have a Function App which inserts some data into on a monthly basis which has failed this month with the following error: Result: Failure Exception: InterfaceError: 2026 (HY000):…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-04-02T15:08:03.6733333+00:00
Chris Sadler 15 Reputation points
commented 2024-07-05T23:31:14.69+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
3 answers

Deployment Failure

I created a MySQL database in Azure and did not have any issues setting it up; however, when I try to run a restore I keep getting the same "Internal Server Error" and my deployment fails. I have tried running it multiple times, using custom…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2022-07-19T14:46:40.927+00:00
CSPBC 6 Reputation points
commented 2024-07-05T23:23:17.87+00:00
Oury Ba-MSFT 18,021 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

MYSQL server fails to deploy

Hi, Im getting the error every time I try to deploy my SQL server: { "code": "DeploymentFailed", "target":…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-06-30T07:50:40.56+00:00
Siddhesh Sreedar 25 Reputation points
commented 2024-07-04T14:17:16.53+00:00
Siddhesh Sreedar 25 Reputation points
0 answers

Mysql is causing reboot to take along time

I am rebooting an Ubuntu VM. The mysql process is failing to stop resulting in the system failing to reboot.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-02T08:33:21.0933333+00:00
Ajit Sarnaik 0 Reputation points
commented 2024-07-04T08:28:15.2633333+00:00
ShaktiSingh-MSFT 14,406 Reputation points Microsoft Employee
2 answers

Cannot defer Auto-Migration of MySQL from Single to FLexible

Hi, I am trying to defer the auto migrate. I get 3 options: 13, 14, 15 August. There is a box to tick to confirm that the pre reqs have been done. I tick that and click Authenticate and I get an error as attached. Can anyone suggest what the issue is…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-01T09:05:59.8433333+00:00
NeilC 31 Reputation points
commented 2024-07-03T18:31:38.4133333+00:00
NeilC 31 Reputation points
3 answers One of the answers was accepted by the question author.

Error deploying "Azure Database for MySQL flexible server"

I am attempting to deploy an "Azure Database for MySQL flexible server", but the deployment is failing with the following error: Status: Conflict. Error code: InternalServerError. Message: An unexpected error occurred while processing the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
asked 2024-07-02T09:07:14.86+00:00
Zarki11 20 Reputation points
commented 2024-07-03T09:05:07.98+00:00
Zarki11 20 Reputation points
0 answers

Problem creating the App Service and the MySQL Database

Good morning, I'm having a problem creating my Azure App Service and MySQL database. When I try to create them through the Azure portal, the deployment process gets stuck and doesn't progress. I've waited a long time, but it seems the deployment never…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
765 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,397 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
241 questions
asked 2024-06-07T09:37:39.13+00:00
Mamadou Oury BARRY 50 Reputation points
edited the question 2024-07-03T04:22:03.34+00:00
Ryan Hill 27,031 Reputation points Microsoft Employee