Azure Database for MySQL is an Enterprise-ready, fully managed MySQL service in Azure.
Questions tagged [azure-mysql-database]
116 questions
0
votes
1 answer
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 default. However, executing SHOW PLUGINS reveals that…
Nial Perry
- 3
- 2
0
votes
1 answer
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 the correct values from the database
import…
Jose
- 25
- 1
- 5
0
votes
0 answers
Unable to export Azure MySQL table to CSV
I found more than one post saying that to accomplish the task we have to run
SELECT * INTO OUTFILE 'file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table
If I run this as administrator I…
Franco Tiveron
- 2,364
- 18
- 34
0
votes
2 answers
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. My question is what is the correct way to have…
Suresh
- 9
- 3
0
votes
0 answers
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 update the values which are null in existing…
NIKI
- 1
- 3
0
votes
2 answers
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 completed, I would like to delete those copied…
Ghansham Mahajan
- 31
- 3
0
votes
2 answers
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', 'my_password');
define('DB_HOST',…
supmethods
- 525
- 6
- 18
0
votes
2 answers
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 in the same Virtual Network I try to connect to…
Sasha
- 11
- 1
- 3
0
votes
2 answers
MySQLdb._exceptions.OperationalError: (2002, "Can't connect to server on '.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.backends.mysql',
'HOST':…
Anish
- 19
- 1
- 8
0
votes
1 answer
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 and connect to MySQL, however, that code is not…
Ranbir Sinha
- 91
- 2
- 9
0
votes
2 answers
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 Database for MySQL single server manually.
After…
PRAVEEN PDBR
- 423
- 1
- 9
- 25
0
votes
2 answers
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: Gen5, 16 vCores,
Business Critical: Gen5, 4…
luck_26
- 7
- 4
0
votes
0 answers
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 databases are version 5.7.32.
When the app is connected…
user3075978
- 775
- 1
- 8
- 30
0
votes
1 answer
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 nothing happens:
user@ubuntu2004:~$ mysql -uuser…
emil
- 31
- 1
- 7
0
votes
1 answer
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 created, but "gtid_mode" "ON" isn't working I am getting following…
Muhammad Zaman
- 89
- 2
- 14