Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
739 questions
2 answers
One of the answers was accepted by the question author.
Mysql Flexible Server not restarting and now not excluding
I configured a Mysql Flexible server and after adjusting the server parameters it tried to restart and stayed in this process for 40 minutes. I gave up and am setting up a new Mysql server. The first server I ordered to delete and has been stuck in this…
asked 2024-05-20T00:13:39.26+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, 36%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Alessandro Pinto
25
Reputation points
answered 2024-05-20T08:00:55.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(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
14,186
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Azure Data Flow Sink - Connection string is not valid or missing Server/User/Database properties
Could you please assist here to resolve this issue below ? We are trying to read Delta table and store it as table in Azure SQL Database as using ADF Data Flow. Source Delta table via inline dataset from ADLS Gen2 its working fine and slink is getting…
asked 2024-05-13T06:36:57.6633333+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, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kashif Ahmed
40
Reputation points
accepted 2024-05-20T05:09:42.0966667+00:00
Kashif Ahmed
40
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Logic App - 502 Bad Gateway Azure Database MySQL Flexible Server
I have created an Azure Logic App with public access (Inboud) and VNET integration in the outbound. This is the network config: On the other hand, in the Virtual Network linked to the Logic App, there is a private Azure Database MySQL Flexible Server.…
asked 2024-05-16T06:25:55.0433333+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, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Miguel Ángel Chuecos Piera
20
Reputation points
accepted 2024-05-17T15:46:26.33+00:00
Miguel Ángel Chuecos Piera
20
Reputation points
1 answer
What's going on with the flexible mysql database ?
Hello, For several days now, I've been experiencing completely unexplained cpu load peaks on my flexible mysql server (B1MS). No metrics, no maintenance, no increase in requests or connections are to blame at this time. As proof, I've disconnected my…
asked 2024-04-09T08:30:32.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(112.00000000000001, 67%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zhaerius
5
Reputation points
commented 2024-05-15T06:35:23.5533333+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(35.2, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Craig Chandler
5
Reputation points
1 answer
i have install mysql server and workbecnh in vm . how i can access database out of network.
i have install mysql server and workbecnh in vm . how i can access database out of network
asked 2024-05-10T07:27:51.0066667+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, 23%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
vishal bhanushali
0
Reputation points
answered 2024-05-14T04:23:01.9733333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
1 answer
Deleted resources are getting billed
I had created mySQL database I have deleted the database as well as the resource group associated with the database some 5 - 6 months back. I still get billed for this. What should I do to stop this wrong billing?
asked 2024-05-13T05:07:16.9233333+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, 79%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Abhijit Ghosh
0
Reputation points
edited an answer 2024-05-13T05:42:06.8233333+00:00
TP
81,381
Reputation points
2 answers
Unable to Modify innodb_dedicated_server variable in Azure Database for MySQL (Flexible Server) - Workarounds or Alternatives?
I'm trying to optimize performance for my Azure Database for MySQL (Flexible Server) instance. In my research, I found the innodb_dedicated_server parameter, but it's greyed out in the Azure portal, indicating it's non-modifiable,can i change this…
asked 2024-05-09T09:57:21.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(96, 79%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Niket Kumar Singh
235
Reputation points
answered 2024-05-10T04:09:23.7533333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
1 answer
How to fix "AzureKeyVaultKeyNotFound" during deployment
I would like to deploy MySQL Database server. But during deployment I got an error like { "code": "AzureKeyVaultKeyNotFound", "message": "Could not find Azure Key Vault Key with key name 'Key…
asked 2024-05-08T20:26:11.08+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, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
C0nstanta
0
Reputation points
answered 2024-05-08T21:16:14.93+00:00
hossein jalilian
4,540
Reputation points
1 answer
Azure Database for MySQL flexible server unexpected increase in CPU usage
I'm running a base B-tier burstable Azure Database for MySQL instance that holds the data for a Strapi CMS backend for a client NextJS website. The CMS and subsequently the database are are not being accessed regularly, only for data updates and the…
asked 2024-05-07T19:57:52.45+00:00
Owen Abkes
0
Reputation points
commented 2024-05-08T20:35:22.72+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server
Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…
asked 2021-05-03T11:51:51.583+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(80, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Lynn Carelse
21
Reputation points
answered 2024-05-06T23:54:14.06+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, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Santiago Guerrero Toro
0
Reputation points
1 answer
Azure database for MySQL - foreign key checks option
Hello M, Can you help us with a variable to manage the foreign_key_checks option is basic variable to migrate data.
asked 2021-10-14T15:05:39.163+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, 98%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jesus Gaibor Yanez
1
Reputation point
commented 2024-05-06T16:26:47.0766667+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, 87%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Dario Carta Mantiglia
5
Reputation points
0 answers
!!Email_me_if_you_want_your_database_dbfile@proton.me
!!Email_me_if_you_want_your_database_dbfile@proton.me This appeared in my MySql server on an Azure VM. They also deleted 30 database. It looks like it is an empty database and they just used the name to send a message. The database can not be dropped Is…
asked 2024-05-03T09:07:59.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(259.20000000000005, 20%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Phillip Hamilton
0
Reputation points
commented 2024-05-04T07:34:27.2833333+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(102.4, 13%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sailesh kumar
0
Reputation points
2 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):…
asked 2024-04-02T15:08:03.6733333+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(236.8, 72%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chris Sadler
10
Reputation points
commented 2024-05-01T17:14:51.4933333+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Using REPLICATE_REWRITE_DB in Azure MySQL database
Database names in my Master and Replica server are different. Master DB name - uas-tms-20211111 Slave DB name - uas-tms-uat To get the replication working in this scenario, we use REPLICATE_REWRITE_DB option in on-prem MySQL servers. …
asked 2024-04-23T12:20:53.6433333+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, 43%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Srikar Gondesi - UAS Database Administrator
85
Reputation points
commented 2024-04-29T12:18:04.9633333+00:00
Srikar Gondesi - UAS Database Administrator
85
Reputation points
1 answer
Azure MySQL Flexible Server Extremely Slow
I have a database server (MySQL Flexible) and it was working fine, but the last few days it has become very slow. There were no changes in the application, the code of application did not change. In the information_schema.processlist there are no active…
asked 2024-04-04T16:08:44.34+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(156.8, 72%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EID%3C/text%3E%3C/svg%3E)
Igor Deutsch
0
Reputation points
commented 2024-04-27T10:21:15.4133333+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(236.8, 79%, 32%)' 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)
Rahul Randive
8,921
Reputation points Microsoft Employee
1 answer
Deployment for MySQL server fails
I'm trying to set up my first MySQL server on azure, but deployment keeps failing with error: { "status": "Failed", "error": { "code": "AzureKeyVaultKeyNotFound", …
asked 2023-04-20T07:53:50.0966667+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(57.599999999999994, 90%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
»CLØnÊ« Who
0
Reputation points
commented 2024-04-27T10:09:43.21+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, 42%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Tim Murphy
0
Reputation points
2 answers
Deleted table restore
Is it possible to recover the deleted table in azure database ? if yes please tell me how ?
asked 2024-04-26T01:28:18.4566667+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(169.60000000000002, 47%, 26%)' 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)
VIKAS GOLE
0
Reputation points
answered 2024-04-26T03:51:00.6133333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
2 answers
Unable to create an Azure MySQL flexible server
I am receiving an error message when trying to create a new Azure MySQL flexible server database in the Southeast Asia region. The error states that "Subscription <name> is not allowed to provision in Southeast Asia." I already have one…
asked 2024-02-26T06:13:34.3666667+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, 61%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LonLee
11
Reputation points
commented 2024-04-24T05:28:33.35+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(188.79999999999998, 15%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Elvin Cheah
0
Reputation points
2 answers
Is there any transactional SQL for creating firewall rule using sp_set_firewall_rule in Azure MI
Hi Team, Can you please let us know, is there any transactional SQL for creating firewall rules using sp_set_firewall_rule in Azure Managed Instance? Thanks, Abhishek Modi
asked 2024-04-22T12:26:02.4033333+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(80, 77%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek Modi (amodi)
0
Reputation points
answered 2024-04-22T15:03:28.0966667+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(134.4, 95%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Abhishek-MSFT
181
Reputation points Microsoft Employee
1 answer
I am using the Student version of Microsoft azure. Can I create Data lake and Data warehouse with this version?
I am student in CIT , Coimbatore.I want to explore the concepts of Data warehouse so I choosed Microsoft azure student version.Can I create warehouse in this version if not please suggest another platforms to create effective warehouses for free.
asked 2024-04-18T05:01:48.5133333+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(137.6, 25%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHK%3C/text%3E%3C/svg%3E)
Harish Kumar
0
Reputation points
edited an answer 2024-04-18T07:38:57.85+00:00
Sumarigo-MSFT
44,416
Reputation points Microsoft Employee