Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
831 questions
4 answers
One of the answers was accepted by the question author.
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…
asked 2024-10-11T20:08:49.3566667+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(19.2, 34%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Alex Rothberg
20
Reputation points
accepted 2024-10-16T16:30:22.68+00:00
Alex Rothberg
20
Reputation points
0 answers
Auto migration from Single server to Flexi server of MySQL server is shown successful, but it is not at all listed anywhere and my apps are not able to connect
There had been an auto migration from my single server MySQL to Flexible server as follow: Migration and cutover to Azure Database for MySQL Flexible Server 'advith-production-mysql-server' completed successfully. While the migrated Flexible Server is…
asked 2024-10-15T06:12:20.0733333+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, 34%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
System Administrator
0
Reputation points
commented 2024-10-16T15:51:40.24+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,715
Reputation points Microsoft Vendor
1 answer
I cannot deploy a MySQL Flexible database to US EAST
As the title says. Everytime I go to deploy a MySQL Flexible database to US East it fails to deploy. It says to select another region but that service is available in US East according to MS's website which is confusing. How can I resolve…
asked 2024-10-15T20:01:17.1566667+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(163.2, 73%, 25%)' 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)
Shaun
0
Reputation points
answered 2024-10-15T20:40:16.2466667+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
555
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
powerbi on-premises data gateway
I am using azure mysql, however, if I need to access this database from powerbi, should I use a data gateway for "on-premises". As this database reside in the "same" cloud as the de powerbi service, I supposed that the could be…
![](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(224.00000000000003, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
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…
asked 2024-10-09T11:54:25.5866667+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(278.4, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jonathan Tono Puchol
25
Reputation points
accepted 2024-10-15T06:37:50.63+00:00
Jonathan Tono Puchol
25
Reputation points
1 answer
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…
asked 2023-09-05T06:30:44.19+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(3.2, 28.000000000000004%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dakornarayan Chandra
15
Reputation points
commented 2024-10-15T05:09:12.77+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, 4%, 31%)' 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)
ShaktiSingh-MSFT
15,321
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…
asked 2024-05-24T02:26:50.82+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(198.4, 60%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Syaza Liyana
25
Reputation points
commented 2024-10-10T23:55:52.2866667+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(83.2, 63%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Henry Le
5
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…
asked 2024-09-18T14:01:28.27+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, 43%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
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…
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…
asked 2024-10-07T08:12:44.8466667+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(240, 10%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
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…
asked 2024-09-15T15:37:05.63+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(118.4, 84%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQT%3C/text%3E%3C/svg%3E)
Quan Truong
0
Reputation points
commented 2024-10-10T01:58:09.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(204.8, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sai Prasanna Sinde (Quadrant Resource LLC)
430
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:…
asked 2024-07-31T16:14:29.7766667+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, 49%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
Dev Ops
0
Reputation points
commented 2024-10-09T22:02:28.24+00:00
Oury Ba-MSFT
19,331
Reputation points Microsoft Employee
1 answer
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
asked 2024-10-09T00:19:39.14+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(54.400000000000006, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWP%3C/text%3E%3C/svg%3E)
Wenbo Peng
0
Reputation points
answered 2024-10-09T04:51:24.8066667+00:00
ShaktiSingh-MSFT
15,321
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…
asked 2024-10-03T02:53:54.4333333+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, 59%, 16%)' 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)
Josh Barth
0
Reputation points
commented 2024-10-07T17:47:02.24+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
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…
asked 2024-10-01T10:11:15.0566667+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(182.40000000000003, 96%, 27%)' 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)
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…
asked 2024-09-30T17:48:51.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(291.2, 15%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
vandana
0
Reputation points
commented 2024-10-04T17:24:58.3266667+00:00
NIKHILA NETHIKUNTA
2,715
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:…
asked 2024-09-27T17:38:21.8666667+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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGA%3C/text%3E%3C/svg%3E)
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…
asked 2024-09-10T20:01:20.3033333+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, 22%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Saima Adeni
10
Reputation points
edited a comment 2024-10-04T04:32:31.51+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(153.6, 92%, 24%)' 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)
ajkuma
26,216
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
asked 2024-09-24T18:46:49.87+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(246.4, 46%, 33%)' 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)
Nisarg Shah
0
Reputation points
commented 2024-10-01T19:38:54.06+00:00
Oury Ba-MSFT
19,331
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…
asked 2024-09-17T04:05:43.1833333+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(310.4, 30%, 40%)' 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
10
Reputation points
answered 2024-09-30T09:24:54.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(227.2, 92%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVL%3C/text%3E%3C/svg%3E)
Videsh Lingabavan
0
Reputation points