828 questions with Azure Database for MySQL tags

Sort by: Updated
1 answer

Issues with MySQL single server migration to Flexible Server

My MySQL single server was migrated to Flexible Server this morning. It has been more than 12 hours and I cannot see the new instance in the azure portal or the azure cli. My application is not able to connect to the new server. In the console I get a…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-10-11T20:08:49.3566667+00:00
Alex Rothberg 0 Reputation points
commented 2024-10-12T02:36:16.4233333+00:00
Alex Rothberg 0 Reputation points
1 answer

Cannot access MySQL from Windows VM since auto migration

Hello, We've just had a auto migration from our MySQL single server to MySQL flexible server. After the migration we can connect to the mysql server locally, but not from our windows VM. Since the flexible server is not visible yet we cannot check…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-10-09T11:54:25.5866667+00:00
Jonathan Tono Puchol 5 Reputation points
commented 2024-10-11T14:44:51.2+00:00
Oury Ba-MSFT 19,176 Reputation points Microsoft Employee
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.
828 questions
asked 2023-09-05T06:30:44.19+00:00
Rakesh Dakornarayan Chandra 10 Reputation points
commented 2024-10-11T13:21:15.19+00:00
John Bevan 6 Reputation points
1 answer One of the answers was accepted by the question author.

How to specify a local timezone on an Azure SQL server?

I have a SQL server on Azure, and I would like to adjust the timezone setting to reflect my local time, which is UTC+8. The current getdate() function shows results in UTC. Is there a way to change the timezone setting to my local time? I am aware of the…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-05-24T02:26:50.82+00:00
Syaza Liyana 25 Reputation points
commented 2024-10-10T23:55:52.2866667+00:00
Henry Le 0 Reputation points
1 answer

Unable to delete subnet delegate to Microsoft.DBforMySQL/flexibleServers

I have a subnet delegated to Microsoft.DBforMySQL/flexibleServers. I integrate MySql flexible server to that subnet, for test purpose. Now I delete MySQL server and I want to delete subnet as well, but azure does not allow me to do this. Please help me…

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,452 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-18T14:01:28.27+00:00
Mykhailo Vasylchenko 0 Reputation points
commented 2024-10-10T11:33:22.48+00:00
Mykhailo Vasylchenko 0 Reputation points
4 answers One of the answers was accepted by the question author.

Unable to Delete Azure Virtual Network

I am attempting to delete an Azure virtual network but keep receiving the error message: "Failed to delete virtual network ''. Error: Subnet iat-5e5de8a6ba-dbsubnet is in use by…

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,452 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2023-12-15T15:51:26.79+00:00
Jorge Insfran 20 Reputation points
commented 2024-10-10T11:06:37.4766667+00:00
Mykhailo Vasylchenko 0 Reputation points
1 answer One of the answers was accepted by the question author.

What is the difference between Server less SQL and SQL Database?

When I use sever less SQL with Azure Synapse Analytics, it provided me an endpoint, And when I use that endpoint in Power Bi, and Microsoft SQL Server Management Studio it shows that A Database is there and show me all files, but when When I use Azure Ai…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,015 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-10-07T08:12:44.8466667+00:00
Lovedeep Singh 165 Reputation points
accepted 2024-10-10T07:22:19.9066667+00:00
Lovedeep Singh 165 Reputation points
1 answer

Can't delete virtual network or subnet due to Service Association Link (SAL)

Hi, I'm getting below error while deleting the VNET. Failed to delete virtual network ''. Error: Subnet strapi-demoDbSubnet is in use by…

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,452 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-15T15:37:05.63+00:00
Quan Truong 0 Reputation points
commented 2024-10-10T01:58:09.49+00:00
Sai Prasanna Sinde (Quadrant Resource LLC) 425 Reputation points Microsoft Vendor
1 answer

Internal server error while creating azure mysql server

{ "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-07-31T16:14:29.7766667+00:00
Dev Ops 0 Reputation points
commented 2024-10-09T22:02:28.24+00:00
Oury Ba-MSFT 19,176 Reputation points Microsoft Employee
0 answers

How to fix ERROR 1045 (28000): Access denied for user 'ecommerceapp@mydbserver1'@'myip' (using password: YES)

Hello, I am using Windows 10. I have an Azure Database for MySQL flexible server that I can successfully connect to using my local MySQL workbench. However, when I use mysql -h

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,528 questions
asked 2024-10-09T00:19:39.14+00:00
Wenbo Peng 0 Reputation points
commented 2024-10-09T04:51:24.8066667+00:00
ShaktiSingh-MSFT 15,311 Reputation points
1 answer

Can Write To Azure SQL Database, Cannot Read

I am so confused on this one. I have been able to write to my Azure Database for MySQL flexible server using python, it works no problem, it uploads my data and I can see the new tables and I can actually read those tables on my wix website no problem. I…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-10-03T02:53:54.4333333+00:00
Josh Barth 0 Reputation points
commented 2024-10-07T17:47:02.24+00:00
Mahesh Kurva 245 Reputation points Microsoft Vendor
1 answer

Possible MySQL database data loss

Hello, We noticed some of our records in the database are missing. We send SMS thourgh our backend and keep the logs in the database. We noticed some people have received our SMS but I don't see any records in the database for them. It is not…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-10-01T10:11:15.0566667+00:00
S Mahdi Seifollahi 0 Reputation points
commented 2024-10-04T18:47:47.5366667+00:00
Sai Raghunadh M 555 Reputation points Microsoft Vendor
0 answers

How to get Employees Hierarchy

Hi, My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP. Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7…

Azure Table Storage
Azure Table Storage
An Azure service that stores structured NoSQL data in the cloud.
170 questions
Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
55 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,638 questions
asked 2024-09-30T17:48:51.62+00:00
vandana 0 Reputation points
commented 2024-10-04T17:24:58.3266667+00:00
NIKHILA NETHIKUNTA 2,630 Reputation points Microsoft Vendor
1 answer

Retrieve correct information about publicNetworkAccess for Azure MySQL flexible server

Hi! I'm using the rest api to retrieve information abot Azure Database for MySQL flexible server. In particular, I'm using this endpoint to list all the servers:…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-27T17:38:21.8666667+00:00
Gonzalo Avalos Ribas 0 Reputation points
commented 2024-10-04T15:30:40.86+00:00
Mahesh Kurva 245 Reputation points Microsoft Vendor
0 answers

How do I access PHPmyadmin in WordPress as App Service (Linux) with Managed Identities turned on?

Hello Community, We need to access PHPmyadmin to manage our MySQL Database used for WordPress. We are using Standard Hosting Plan of Azure with WordPress on App Service (Linux based) with Managed Identities activated. Now the issue is that we are not…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,778 questions
asked 2024-09-10T20:01:20.3033333+00:00
Saima Adeni 10 Reputation points
edited a comment 2024-10-04T04:32:31.51+00:00
ajkuma 26,141 Reputation points Microsoft Employee
2 answers

Azure SQL Server Single instance auto migration authorization not saving (Spinning)

Auto-migration authorization is not saving and just spinning. Cannot save these changes to have microsoft to migrate our SQL database

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-24T18:46:49.87+00:00
Nisarg Shah 0 Reputation points
commented 2024-10-01T19:38:54.06+00:00
Oury Ba-MSFT 19,176 Reputation points Microsoft Employee
1 answer

DB Connection Failed SQLSTATE[HY000] [2002]

Hello All, We have azure web app with Linux OS, php 7.4 stack, publish mode is code and we are using default domain over the same. We are trying to connect the same with MYsql flexible server (Business Critical, E2ads_v5, 2 vCores, 16 GiB RAM, 100 GiB…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
935 questions
asked 2024-09-17T04:05:43.1833333+00:00
Saurabh Sharma 10 Reputation points
answered 2024-09-30T09:24:54.83+00:00
Videsh Lingabavan 0 Reputation points
1 answer

Metrics - Resource not found message

When creating a new chart Im getting the following error: Resource not found

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-25T00:32:09.5966667+00:00
Soltec Soltec 0 Reputation points
answered 2024-09-27T16:43:45.46+00:00
youzeliang 735 Reputation points
2 answers One of the answers was accepted by the question author.

Error on sink data to MySQL - communications link failure

I've got a Pipeline with some Data Flow activities that runs in parallel. I've got the error on last night's execution and I'd like some help to understand why and how to prevent it from happenning. Job failed due to reason: at Sink 'EnviaFerias':…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,712 questions
asked 2024-09-19T11:24:37.3633333+00:00
accepted 2024-09-27T11:19:59.9+00:00
1 answer

Azure Mysql flexible server - reduce storage size by purging binlog via binlog_expire_seconds

I have set the server parameter binlog_expire_seconds to 30 in Azure mysql flexible server. I was trying to signal the server to purge the binlog in order to reduce the storage size, but the storage size didn't change at all. Any ideas?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
828 questions
asked 2024-09-20T03:06:44.0966667+00:00
Avan Tan 0 Reputation points
commented 2024-09-24T15:40:28.98+00:00
Sai Raghunadh M 555 Reputation points Microsoft Vendor