Azure SQL Database
An Azure relational database service.
5,120 questions
1 answer
About MYSQL Files
Can I recover my MYSQL data using Other PC without backup save? but I have the folder files of MYSQL. Scenario is My Computer can't start up, and the OS is busted what I did is get a new hard drive and boot a OS on it and I setup my old drive(with the…
asked 2022-04-20T22:36:38.813+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(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mumay
1
Reputation point
commented 2022-04-22T14:07:21.24+00:00
GeethaThatipatri-MSFT
27,022
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Want to store .sql files to azure blob using adf
Hi , I am using third party tool which exports .sql scripts daily . I want to store those .sql scripts in azure blob (if possible without using azure mysql db instance) using adf in the form of tables and then i will use those tables for analytical…
asked 2022-04-14T06:16:34.01+00:00
Amar Agnihotri
891
Reputation points
commented 2022-04-21T06:31:42.263+00:00
Amar Agnihotri
891
Reputation points
1 answer
One of the answers was accepted by the question author.
Restore MySQL to different vNet - InternalServerError
Hello, I am trying to "migrate" Azure Database for MySQL flexible server running in Azure to new subscription with new RG and new vNet create. I choose approach with restore where I can select different vNet and subnet where I wan to connect…
asked 2022-04-08T13:10:15.733+00:00
Oldrich Srubar
61
Reputation points
commented 2022-04-19T14:03:31.793+00:00
GeethaThatipatri-MSFT
27,022
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
How can I reset the password on an Azure Mysql Flexible instance?
I've been struggling for a few days now with an Azure Mysql flexible instance. I can still connect to it with the lesser privileged user accounts I created and access the data, however I need to take a mysqldump of all the data so I need to use the…
asked 2022-04-13T15:16:02.903+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(211.20000000000002, 89%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EJ Marmonti
141
Reputation points
answered 2022-04-16T18:55:06.183+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, 15%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pariks-MSFT
1
Reputation point Microsoft Employee
1 answer
In SQL, what are the differences between Inner Join, Left Outer Join and Right Outer Join?
Also, what is the correct format for performing a Join?
asked 2022-04-12T08:00:53.053+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(144, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Abhinaya Koshy
1
Reputation point
commented 2022-04-15T06:06:10.587+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(108.80000000000001, 46%, 20%)' 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)
AmeliaGu-MSFT
13,961
Reputation points Microsoft Vendor
2 answers
Connecting web api to MySQL in app.
Hello, I'm using a web API for a project where I'm working on, the problem is, when i try to connect to the MySQL In app I get this error: One or more errors occurred. (An attempt was made to access a socket in a way forbidden by its access…
asked 2022-04-13T21:34:20.363+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, 59%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EmielD
1
Reputation point
answered 2022-04-14T17:55:37.767+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
55,601
Reputation points
1 answer
Options for Scaling Azure for MySQL Instance Beyond 16tb
Our Azure Database for MySQL server is growing ( around 6 tb ) and we are wondering what are the options when we reach the 16 tb storage limit? Is there a different server option that will allow us to scale the dataset past 16 tb within a single region…
asked 2022-04-14T04:35:28.633+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(272, 32%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Deep Space
1
Reputation point
answered 2022-04-14T09:24:05.11+00:00
Sam Cogan
10,157
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
when trying to create MYSQL flexible server getting ERROR: (InternalServerError) An unexpected error occured while processing the request error.
Using Azure CLI trying to create MYSQL Flexible server and getting the below error. here is the error ERROR: (InternalServerError) An unexpected error occured while processing the request. Tracking ID: 'e67fb02f-8235-40d8-9758-e5bdf16880ac' …
asked 2022-03-08T11:12:14.863+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, 54%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
katta nagaraj kumar
21
Reputation points
commented 2022-04-09T07:28:08.817+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, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
Katta NagarajKumar
1
Reputation point
2 answers
Changing Azure MySQL Port
Hi all, Is it possible to change a MySQL Port to something other than the default? We have a business request to change the default port for a new Azure MySQL DB, but I do not see anywhere within the parameters section that give me that ability. Is…
asked 2022-03-31T20:23:12.2+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, 80%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Oscar
1
Reputation point
answered 2022-04-05T18:26:05.977+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
is this okay?
question answered
![](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, 97%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E6%3C/text%3E%3C/svg%3E)
1 answer
MySQL Flexible Server deployment get stuck
I'm trying to deploy MySQL Flexible in North Europe but the process get stuck (waited for like 1hr) Deploying it to another region is pretty quick, 5 minutes or so. Any idea?
asked 2022-03-23T14:41:14.71+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, 86%, 28%)' 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)
Stefano Azzalini
1
Reputation point
commented 2022-04-03T14:53:09.1+00:00
GeethaThatipatri-MSFT
27,022
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
network, ip addresses limit?
I have 14 ip addresses in my database rules, I'm trying to add more but it won't, the success message appears more after updating the page the rule disappears, only the 14 that I had already entered are left
![](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, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
About MYSQL azure
I created my database all normal, but when I try to connect using 'mysql workbanch' it just doesn't work, I already added my ip in the rules, and the database is public, but it still won't. is there anything else to do? sorry for my bad english
2 answers
One of the answers was accepted by the question author.
About MYSQL azure database
Topic to proceed help with @Takahito Iwasa https://prnt.sc/zN0wDxRnqNgy it works, the problem is in azure, what can i do? I had already recreated the bank but it still didn't work
1 answer
One of the answers was accepted by the question author.
Firewall error while connecting Database server to Azure Data Studio
I am doing the exercise in sandbox environment named "Architect modern applications using Azure SQL Database". On page 5 under "Connect to Azure SQL Database with Azure Data Studio" - point 4, I can not finishing setting up the…
![](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(208, 84%, 30%)' 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)
2 answers
One of the answers was accepted by the question author.
Setting binlog_row_metadata to FULL in Azure DB for MySQL
I'm setting up an Azure database for MySQL and attempting to enable CDC but having trouble. To do so using the service that I'd like to use, I need to be able to set binlog_row_metadata to 'FULL', but that doesn't seem available in the UI either on a…
asked 2022-03-09T21:05:22.467+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, 49%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dave
21
Reputation points
commented 2022-03-29T20:33:53.927+00:00
Oury Ba-MSFT
16,076
Reputation points Microsoft Employee
0 answers
Azure Data Factory - MySQL ODBC Operation Failed (The Connection Has Been Disabled)
We keep continuing to get this error message when trying to copy a large set of data (around 45 million records) from MySQL Table to AzureSQL Database Table. Pipeline always starts fine and run for the first couple of minutes and then stops with the…
asked 2022-03-23T15:15:24.707+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(185.6, 86%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Goyal, Saurabh
11
Reputation points
commented 2022-03-28T19:12:50.417+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(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
3 answers
Mysql Query Error
Error: What is Error here? mysql> create table fruitsdb(fruitsid int(20),fruitsname varchar(255),fruitsyear int(10),quality varchar(255),taste varchar(255),sales varchar(255)) -> select * from fruitsdb; ERROR 1146 (42S02): Table…
asked 2022-03-26T06:00:18.753+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(249.60000000000002, 82%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mohamed Rafi N
106
Reputation points
answered 2022-03-28T06:46:11.423+00:00
Olaf Helper
40,741
Reputation points
1 answer
One of the answers was accepted by the question author.
Insert button Code and Mysql data to be save and display in grdiview
I am very new and using visual studio community 2000 and mysql work bench 8.0, I am having 3 textbox names like textbox1,2,3 and 1 insert button and 1 data gridview for saving data in mysql database, i need code for insert button.. This is mysql…
asked 2022-03-17T11:49:08.293+00:00
Mohamed Rafi N
106
Reputation points
commented 2022-03-26T04:26:32.17+00:00
Mohamed Rafi N
106
Reputation points
0 answers
I am using AZure manage instance and ADF , but when I trying to linked that from link services it gets error code 22300
When I try to link the service it gets " Cannot connect to SQL Database: 'azeus-prd-msql1.public.3fcfbafa18fd.database.windows.net,3342', Database: 'DBMaintenance1',User: 'ADF_Test'. Check the linked service configuration is correct, and make…
asked 2022-03-25T07:41:11.933+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, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mawantha
1
Reputation point
commented 2022-03-25T15:41:55.313+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, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,571
Reputation points