128 questions
0
votes
1
answer
81
views
Unable to import/export database tables via MySQL Workbench after changing Azure SQL security access due to `unknown option` error
For contextual reasons, we recently changed security access from (MySQL & Microsoft Entra Auth) to (Microsoft Entra Auth ONLY):
After doing this, I am no longer able to import/export database via ...
0
votes
1
answer
350
views
How to use both Service Principal and System Assigned Identity in Django on Azure Container Apps?
Before using Azure Container Apps (ACA), I deployed my applications on Kubernetes (AKS). In AKS, I only had to set environment variables for authentication, and the Python SDK for Azure would connect ...
0
votes
1
answer
77
views
az mysql flexible-server show returns null
I am creating a mysql server in Azure via Azure DevOps. I have run into an issue and would like to confirm if it is a bug or something I am doing wrong.
I have a bash script that creates the mysql ...
0
votes
1
answer
92
views
Does MySQL return results ordered by id when using LIMIT with an increasing id condition? [duplicate]
I’m optimizing a query for better performance, and I use the following SQL statement:
SELECT * FROM my_table
WHERE status_flag = 0
AND event_date = '2025-03-25 23:59:59.999'
AND id > 42006893
...
0
votes
1
answer
159
views
How to add mysql database to azure app service backups using managed identities
I have a wordpress app service setup in azure and it applies automatic backups every hour. However, this does not include a database backup so when you go to custom backup you can choose advance and ...
2
votes
1
answer
69
views
Which MySql system table holds information about SHOW_ROUTINE privileges?
I would like to retrieve information from a MySql instance, which users have SHOW_ROUTINE privilege.
This privilege can be only granted globally according to the documentation. Such privileges are ...
0
votes
1
answer
216
views
Unable to create Azure Flexible MySQL database, key vault not found error
Im trying to create Azure Flexible MySQL database, I tried multiple times by providing key vault and managed key information. Still it showing Could not find Azure Key Vault Key with key name
...
1
vote
1
answer
498
views
MySQL with TLS connection in NestJS
In my NestJS backend I wanted to add a TLS connection for my database which is in MySQL. My MySQL is on Azure and I have turned off the require_secure_transport = OFF now if I turn on, I get this ...
0
votes
1
answer
125
views
Can we connect to Azure MySQL database from Google Data Studio
Is there a way to create a data source to Azure MySQL database in Google Data Studio?
What is the public IP of Google Data studio that I can give access to in my Azure MySQL database?
Thanks in ...
1
vote
1
answer
470
views
How to Configure .NET 7 web application to access Azure MySql Flexible Server with managed Identity?
I have a web application with .NET 7 that uses MySQL, I wanna deploy this app to a WebApp on Azure, but before that, I am trying to access the db using Azure managed Identity and not MySql User and ...
-1
votes
2
answers
199
views
Azure Wordpress MySQL performance [closed]
I have 3 mariadb galera db's, 2 nginx/php machines at these sizes
DBs - E8ds_v5, nginx/php-fpm - D4ds_V5
I am getting really bad performance from mariadb. These machines are in the same vnet, but ...
0
votes
1
answer
3k
views
Can't connect to Azure MySQL flexible server, any ideas why?
I am trying to connect to the azure mysql flexible-server from MySQL workbench / azure-cli but have not been successful.
I have allowed connections to the server from my current IP. I followed the ...
0
votes
1
answer
474
views
Use MySQL Flexible Server as data source for AI Search Service indexer
I'm using a MySQL Flexible Server as data source for an Indexer in my AI Search Service. Everything worked smoothly when all the resources were public but I'm having trouble getting it to work in a ...
0
votes
1
answer
1k
views
MySQL Azure database with username/password
We are wanting to use the Azure REST API to create Mysql database server instances as listed here: https://learn.microsoft.com/en-us/rest/api/mysql/?view=rest-mysql-singleserver-2017-12-01#flexible-...
0
votes
2
answers
209
views
Scheduled Event not Executing Properly
I have a mysql event that is scheduled to run nightly defined as follows:
create definer = myuser@`%` event nightly on schedule
every '1' DAY
starts '2023-10-21 00:00:00'
enable
do
...
0
votes
1
answer
145
views
What option do I set for a SQL Server connection pool to use Azure Active Directory authentication?
Trying to connect to a SQL Server database on Azure and use Azure Active Directory instead of using the default SQL authentication. Current options w/ my idea of using set domain but not sure what it'...
0
votes
1
answer
119
views
Website down time and pooled connections were in use .net core MVC Apps
While running a .net Core MVC application against Azure Mysql database, frequently we are getting the sites are running down / going offline issue.
After checking server error logs , we can see many ...
-1
votes
1
answer
326
views
Azure MySQL flexible server showing special characters as codes
After a new instance of Azure MySQL flexible server is setup, i imported data from existing mysql data base using Heidi and it looks like all data is imported but after a deeper look , realised that ...
0
votes
0
answers
159
views
Azure Web App Private Connection to database not working
I have using a public connection to a Azure MySQL database from a Azure Web App using a PHP 7.4 stack (soon to be PHP 8.2). Things work fine up to about 2500 requests/min and I start getting database ...
0
votes
0
answers
43
views
MySQL database - Error: 1045 (28000): Access denied for user 'barginadmin'@'%' (using password: YES) [duplicate]
Note: i tried every single stackoverflow suggestion at the bottom before I posted.. I also tried creating the user in the database on the mySQL command line then granting all permissions, still no ...
0
votes
1
answer
864
views
How to Connect Azure Mysql Database with Django Project
I am trying to connect my Django project with the Azure Mysql database but it's showing this error continuously:
RuntimeWarning: Got an error checking a consistent migration history performed for ...
0
votes
1
answer
337
views
unrecognized arguments: --location while creating the Azure Mysql Flexi -Server Replica create
The requirement is to implement Cross-region replication using Azure MySQL Flexi server DB. From the Azure portal, have the option to choose a location while creating the replica.
The same replica ...
1
vote
1
answer
120
views
Index on character column in Azure DB for MYSQL servers
We are using Azure DB for MYSQL Flexible servers. Its InnoDB v8.
In one of the table few million records exist. Sometimes we need to search record based on one of the column say Name column. Its ...
1
vote
2
answers
258
views
Flutter app Azure MySQL server connection timeout error
I am developing a Flutter application in android studio. In a separate 'DbHelper.dart' file, the following code connects to Azure MySQL server.
DbHelper.dart:
import 'package:mysql1/mysql1.dart';
void ...
0
votes
1
answer
322
views
Backup status alert for Azure Database for MySQL - Single Server
Microsoft documentation:
Azure Database for MySQL - Single Server takes backups of the data files and the transaction log.These backup files are not user-exposed and cannot be exported. These backups ...
0
votes
0
answers
317
views
ghost docker container mysql self signed certificate in certificate chain
I am trying to get my Ghost Blog (https://ghost.org/) running in a Azure Docker Container.
In the Ghost documentation they describe how to configure the SSL connection for a MySQL database. In Azure I ...
3
votes
1
answer
6k
views
Invalid value given for parameter administratorLogin. Specify a valid parameter value
While create mysql server from azure portal, i am getting like this
{
"code": "DeploymentFailed",
"message": "At least one resource deployment operation failed. ...
0
votes
1
answer
1k
views
Azure for MySQL (Single Server): occasional connection timeouts (2003, Can't connect to mysql server on ... (timed out))
My Python (FastAPI) app is deployed to an AKS cluster (several replicas/pods). It makes requests to a MySQL database managed by "Azure for MySQL Single Server". The app works just fine, but ...
0
votes
1
answer
191
views
Database Connection Problem - Azure MySql Database Server from .net core 3.1
-- Background:
I am using asp.net mvc project with 3.1 .net core.
I have azure setup for hosting it in app service.
For Database, I have mysql database server set up on Azure (version 5.7).
-- Problem:...
0
votes
1
answer
1k
views
Azure mysql single server with private link still resolves to public name
I've setup a MySql single server (we cannot AFAIK use flexible server because we want to configure data encryption which seems problematic on Flexible server).
The MySql single server is setup to ...
2
votes
1
answer
688
views
How to connect an Azure App services to Azure Database for MySQL Flexible Server
I am working on an Azure app services in conjunction with a flexible mysql database server. I have successfully deployed my website to NodeJS v18.LTS, but my server is Throwing: ...
1
vote
1
answer
278
views
MySQL Azure Database | Enable mysqlx plugin
I am trying to enable the mysqlx plugin in my company's MySQL Azure database, so that I can use the JSON import utility in MySQL Shell.
The server version is 8.0, for which mysqlx is enabled by ...
0
votes
1
answer
110
views
Azure Mysql server connection with Azure Synpase Spark doesnt work
I´m trying to connect to an Azure Mysql database server to create a table from a Dataframe in Azure Synapse with Spark.
I have this url and this properties
All variables like jdbcXYZ are fulled with ...
1
vote
1
answer
2k
views
Private IP on Azure MySQL Flexible Server
When creating MySQL Flexible Server (DBaaS) on Azure that is not publicly accessible a private DNS zone is being created making that MySQL Flexible Server accessible via a hostname. While debugging ...
-1
votes
1
answer
482
views
mysql/mariadb: why the connection is not established when i replace DNS with its corresponding IP?
i have deployed mariadb on Azure with ssl enabled.
The server name looks like : somename.mariadb.database.azure.com
i installed mariadb client on my jumpserver. I did nslookup somename.mariadb....
1
vote
2
answers
918
views
Azure database for mysql - cross region read replica
I'm using Azure database for mysql - Flexible server and we would like to have Disaster recovery in another Azure region. As per the below documentation, the cross region read replica is not supported....
0
votes
0
answers
155
views
update only null value columns in table if ID exits in table
I am trying to check for the ID. If it does not exist I want my data to be inserted as a new record in table and if ID exists I want to compare both incoming new record and existing record and only ...
0
votes
2
answers
1k
views
How to execute a MySQL delete query in Azure Data Factory?
I would like to delete the MySQL DB records using ADF.
I have created the pipeline in ADF and I am copying the data from a MySQL Database to Storage Account using copy activity in ADF, once that's ...
0
votes
2
answers
403
views
WordPress and Azure Database for MySQL servers - Error establishing a database connection
I have created a virtual machine hosting a WordPress website and an Azure Database for MySQL.
Sample credentials:
define('DB_NAME', 'wordpress');
define('DB_USER', 'wpuser');
define('DB_PASSWORD', '...
0
votes
2
answers
6k
views
How to connect to Azure SQL sever from Azure AKS cluster via private endpoint
In my Azure environment I have private SQL Server. To access SQL Server and databases I use a private endpoint. When I connect to SQL from VM in the same Virtual Network I have no problem. I have AKS ...
0
votes
2
answers
4k
views
MySQLdb._exceptions.OperationalError: (2002, "Can't connect to server on '<servername>.database.windows.net') | Django+Azure+MySql
I'm having issues connecting my Django app in my local machine to MySql Database in Azure? I added my IP in the Rules and am connecting with this:
'default': {
'ENGINE': 'django.db....
0
votes
1
answer
935
views
Spring Boot App: Login to MySQL database on Azure using system assigned managed identity
I followed this article to create a system assigned managed identity for an app service on Azure and made the necessary AD authrization for MySQL database. The link has a java code to generate token ...
0
votes
2
answers
383
views
How to copy connection security firewall rules,SSL,TLS from one azure DB for mysql to another azure DB for my sql server using powershell
I have restored Azure Database for MySQL single server using powershell script below.
Now, post restore the DB I had to copy all the firewall rules and other settings from connection security of Azure ...
0
votes
2
answers
187
views
how to configure license for AHB
How to calculate how many licenses required for Azure Hybrid Benefit.
below is the configuration for MSSQL db Sql database configuration below:-
General Purpose: Gen5, 2 vCore,
Business Critical: ...
0
votes
0
answers
253
views
Query does not work with Azure Database for MySQL, but works in on-prem MySQL instance
I recently replaced an on-prem MySQL server with Azure Database for MySQL. I have a .NET 6 C# application and it works when connected to the on-prem, but has a problem with the Azure DB. Both ...
-3
votes
1
answer
163
views
MySQL server on Azure portal db cannot use default (current_date)
When running
creation_date date default (current_date),
getting error on MySQL server on Azure portal, but not on local MySQL workbench. How can we give the current date as default?
1
vote
1
answer
1k
views
MySQL cli client hangs when connecting to Azure managed database
I have a MySQL database on Azure, using the Azure managed database service, and two Ubuntu 20.04 VMs (running PHP applications) in the same VNET. I can connect to the database from both PHP, and from ...
0
votes
1
answer
1k
views
Connect to "Azure Database for MySQL-Server" from Ubuntu 20.04
I'm trying to connect from a Ubuntu 20.04 Server to an Azure Database for MySQL-Server from terminal. That worked fine until two days ago.
When i hit enter now the mysql warning is displayed and ...
0
votes
1
answer
798
views
terraform azure mysql gtid_mode "ON" error
i am trying to create mysql with some default configurations on azure with terraform, following is my code. although "enforce_gtid_consistency" and "time_zone" is working and being ...
0
votes
1
answer
197
views
Can 'Temporary Symmetric Keys' be dropped in the same session which created it in Azure SQL?
Even after closing a connection temporary symmetric keys were not deleted from tempdb.sys.symmetrickeys.
I want to understand if I can always drop them in the same session without worrying about ...