Stack Overflow
Stack Overflow

Questions tagged [azure-database-mysql]

"Azure Database for MySQL" is MySQL as-a-service in MS Azure. Use this tag specifically for the azure service "Azure Database for MySQL". DON'T use it for MySQL hosted on a Azure virtual machine.

Azure Database for MySQL is MySQL as-a-service in MS Azure, announced on 10th May, 2017. It provides a managed database service for app development and deployment

70 questions
1
vote
0 answers

Why is a query slow when run through application server vs. when run on mysql terminal?

Back-end architecture: Spring-boot Application + nodeJS server + Azure Mariadb server. The nodeJS server is used to quickly provide data from the DB for initial syncing of the application. It had been working fine but lately, few queries for certain…
Aman Kumar
  • 11
  • 2
1
vote
1 answer

Wordpress site extremely slow after migrating to Azure App Service and Azure Database for MySQL Flexible Sever

I was previously running both my wordpress application and the mysql database server installation inside the same Linux Virtual Machine on Azure. I recently migrated both to Azure App Service and Azure Database for MySQL Flexible Server respectively…
Faye.Zubz
  • 73
  • 1
  • 7
1
vote
2 answers

Client Certificate and Key for Azure Database for MySQL

I want to use an SSL connection for my MySQL databases in Azure, but I can't find out how to get a Client Certificate and Key. Is there a way to get those? I found this article, but this is for a Server Certificate and is not the solution I am…
user3075978
  • 775
  • 1
  • 8
  • 30
1
vote
2 answers

How to access Azure Database from Azure Batch?

I have a Java process inside a Docker container inside an Azure Batch Task. The Java process is trying to simply establish a JDBC database connection to the Azure Database for MySQL service. The connection error includes 'Client with IP address…
Oozman
  • 41
  • 4
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
1 answer

Azure Database for MySQL - webapp nodejs

So I have been working on a web app with local mysql workbench. I recently moved the database to Azure Database for MySQL. Everything was working properly before I moved away from local. All my webpages were working properly, now only 2 out of…
williswin
  • 133
  • 13
1
vote
0 answers

PDO exception on MariaDB connection, peer certificate doesn't match

I'm receiving a PDO exception when attempting to connect to an Azure MariaDB database over SSL. The issue stems from the fact the peer certificate does not match the hostname I am connecting to. I have researched the issue as much as possible. The…
jay
  • 11
  • 2
1
vote
2 answers

Is there any alternative of CREATE TYPE in SQL as CREATE TYPE is Not supported in Azure SQL data warehouse

I am trying to execute this query but as userdefined(Create type) types are not supportable in azure data warehouse. and i want to use it in stored procedure. CREATE TYPE DataTypeforCustomerTable AS TABLE( PersonID int, Name varchar(255), …
gaurav modi
  • 39
  • 2
  • 9
1
vote
0 answers

Connection string for Azure cloud database using Vbscript(UFT) with SSL encryption

how to connect to Azure Cloud database using Vbscript with SSL encryption. I have tried to connect to Azure Cloud DB using ADODB but unable to connect. Checkout my code to recommend me correct code to connect to Cloud DB. And how to add ".jks" file…
Saurav Chauhan
  • 11
  • 4
1
vote
0 answers

Azure Database for MySQL and Azure VM replication connection error

I have provisioned a Azure Database for MySQL instance and for the purposes of debugging I have added to the rule under the connection security section as below: Name: allowAll Start IP: 0.0.0.0 End IP: 247.255.255.255 It does not allow me to…
user3253425
  • 11
  • 2
1
vote
2 answers

mysql command line client says can't connect to Azure Database for Mysql

I was happily using mysql command line in my mac to connect Azure Database for MySql. But all of sudden it started throwing an error saying: ERROR 2003 (HY000): Can't connect to MySQL server on 'XXXXXXXX.mysql.database.azure.com' (61) I can see the…
Arun Prasad Nallathambi
  • 11
  • 3
1
vote
4 answers

API for Azure Database for MySQL

Azure Database for MySQL server is still in preview, though we can created database instance on it. I wonder do we have any API to retrieve the databases that we created on Azure Database for MySQL server? API for metrics of those databases? Same…
Jerry
  • 21
  • 2
1
vote
1 answer

Azure SQL vs Azure Database for MySQL

Now that Azure has started to provide Preview version of PaaS version of MySQL, how do I do an Apples to Apples comparison of Azure SQL and Azure MySQL from a Cost perspective? In AWS RDS world, both SQL Server and MySQL are tied to compute units.…
Sriram Somasuntharam
  • 95
  • 1
  • 9
1
vote
2 answers

sequelize mysql ssl SequelizeConnectionError: ER_HANDSHAKE_ERROR: Bad handshake

I try to connect to an Azure MySQL DB with ssl. new Sequelize('db', 'user', 'pw', { host: '...', port: '3306', dialect: 'mysql', dialectOptions: { insecureAuth: true, ssl: { …
Chris
  • 13,100
  • 23
  • 79
  • 162
1
vote
1 answer

Add another user in Microsoft Azure Database for Mysql Server

I am using Microsoft Azure database for Mysql server in my mysql workbench. Now I have dynamic IP set so every time when changing the place I have to open the Azure and enter my IP manually. Now I want to give access to a friend but I don't want to…
Samvid Jhaveri
  • 67
  • 10
1
2
3 4 5