Stack Overflow
Stack Overflow

Questions tagged [azure-mysql-database]

Azure Database for MySQL is an Enterprise-ready, fully managed MySQL service in Azure.

116 questions
1
vote
1 answer

Azure ARM Template for flexible mysql server gives "Internal Server Error"

I am trying to deploy a MySQL Flexible server cluster using ARM Templates and terraform (since terraform doesn't have any resource for mysql_flexible) but it gives me the following "Internal Server Error" without any meaningful information. Please…
faizan
  • 164
  • 12
1
vote
2 answers

Azure Elastic Pool with Azure SQL Databases and MySQL databases

Fast question: Is it possible to have an Elastic Pool in Azure with Azure SQL Databases and MySQL databases? Or in alternative an Elastic Pool made of Managed Instance and MySQL databases?
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1
vote
0 answers

Getting Error "FeatureSwitchNotEnabled" while creating MYSQL through ARM template

Getting Error "FeatureSwitchNotEnabled" while creating MYSQL through ARM template Hi All, When I create MySQL through ARM Template there are 2 tasks on which I get FeatureSwitchNotEnabled. 1 - Microsoft.DBforMySQL/servers/firewallRules 2 -…
sandeep0101
  • 61
  • 1
  • 4
1
vote
0 answers

"Access denied for user" when trying to access MySQL database from Azure Pipelines

I'm running a MySql database on Azure. My ultimate goal is to add an AADUser to the database from a pipeline in Azure DevOps. An AADUser can only be added by the AADAdmin. So I was thinking to create an AADAdmin based on the service principal that…
t.amsing
  • 169
  • 7
1
vote
2 answers

MySQL firewall rules from an app service's outbound IPs on Azure using Terraform

I'm using Terraform to deploy an app to Azure, including a MySQL server and an App Service, and want to restrict database access to only the app service. The app service has a list of outbound IPs, so I think I need to create firewall rules for…
Chris W
  • 93
  • 8
1
vote
0 answers

Load a file into a "Azure Database for MySQL" instance of MySQL

I'm trying to load some data into a brand new instance of "Azure Database for MySQL". I've been provided with data files and a loading script that includes LOAD DATA INFILE statements. This gives me an "access denied" error: Error Code: 1045.…
Tom Wright
  • 11,278
  • 15
  • 74
  • 148
1
vote
0 answers

Why I can't connect the Azure MySQL database?

I have a problem connecting from eZPlatform 3.0 (based on Symfony 5) to the Azure MySQL database. I get the error: SQLSTATE[HY000] [9002] SSL connection is required. Please specify SSL options and retry. Configuration is as follows: doctrine: …
Aleksandar Jakovljevic
  • 911
  • 5
  • 12
1
vote
0 answers

Cannot turn off only_full_group_by on Azure Database for MySql Server

I'm using Azure Database for MySql Server, and when running a certain stored procedure, I get this error: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'mydatabase.mytable.id'; this is incompatible…
Fabricio Rodriguez
  • 3,769
  • 11
  • 48
  • 101
1
vote
2 answers

How to configure firewall between Azure Container Instance and Azure MySql automatically in Terraform?

I have a terraformed Azure MySQL instance and a WordPress docker instance running in an Azure Container Instance. Both come up fine, but I can't see a way to automatically allow access from the container instance to MySQL because 1) the traffic is…
mikebridge
  • 4,209
  • 2
  • 40
  • 50
1
vote
0 answers

Sysbench on Azure MySQL - SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query

I am having trouble with running sysbench on Azure DB for MySQL. I have a sysbench server on a Azure VM which I am using to connect to Azure MySQL server through remote host. I have used this same sysbench server setup to benchmark another VM on…
Karthik Poojary
  • 11
  • 2
1
vote
1 answer

I can't seem to connect to my Azure Database for MySQL server from my Azure Linux VM

I have a Linux Virtual Machine (Debian 9) deployed in Azure with Service Endpoints for Sql enabled and properly added -if I navigate the portal towards the VNet and enter the Service Endpoints tab, I can clearly see the Sql Service Endpoint listed.…
Roy
  • 27
  • 1
  • 6
1
vote
2 answers

How to connect html to Azure database?

I'm trying to connect my Azure Sql storeage and html to show everything i have. but i'm having some trouble. i researched w3school and other resources but i still don't know what is wrong? so i use Notepad++ and save it as html and use php to…
Eddie Vu
  • 65
  • 1
  • 8
1
vote
0 answers

Turn off backup for an "Azure database for MySql server" resource

I have an "Azure database for MySql server" resource. The database size is 2.5GB. The backup size is 143GB. This has added 10€ to my last invoice, but i'm mostly concerned about how large can it grow in the future, when the application will go from…
Jacopo
  • 525
  • 3
  • 15
1
vote
1 answer

How to grant access on Azure Database for MySQL in the portal?

How can I grant permissions on Azure Database for MySQL in the portal to other user? I don't see 'Access Control (AIM)' for it anywhere.
AlexB
  • 4,167
  • 4
  • 45
  • 117
1
vote
1 answer

configure static/public ip for azure mysql

Azure has provided the access to the mysql instance as the domain name as X.mysql.database.azure.com I am able to connect it properly. But I need to get the public/static ip address which we can use to access this instance. Thank you.
A_01
  • 1,021
  • 11
  • 27
1
2
3 4 5 6 7 8