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
20
votes
3 answers

Connection to Azure MySQL server fails due to incorrect connection string

When trying to connect to my MySQL server in Azure from mysql client, I get the following error, even though I am using the correct username and server name. How can I fix this? The connection string may not be right. Please visit portal for…
Shantanu
  • 2,871
  • 4
  • 24
  • 38
19
votes
5 answers

Why does connection to my MySQL server in Azure fail if my app does not have SSL enabled?

I get a connection failure when I try to connect to my MySQL server in Azure from my app/client, which does not have SSL enabled. The error message is as follows: SSL connection is required. Please specify SSL options and retry. Is SSL mandatory…
Shantanu
  • 2,871
  • 4
  • 24
  • 38
6
votes
1 answer

PHP on Azure App Service slow performance when connected to Azure Database for MySQL

I am hosting a PHP 7.2 website written on CodeIgniter 3 framework on Linux Azure App Service (plan P1v2). The database is MySQL 5.7 running on Azure Database for MySQL (General Purpose, 2vCores, 5GB storage) with SSL disabled. When I browse my…
BlackMiracle
  • 363
  • 2
  • 8
6
votes
3 answers

Creating MyISAM Table in Azure database for MySQL is enable?

When I create table that engine is MyISAM in Azure database for Mysql, Got Error "ERROR 1030 (HY000): Got error 1 from storage engine" How do I fix it? or can I use MyISAM table in Azure database for MySQL?
Yuuji Arakaki
  • 63
  • 1
  • 4
4
votes
1 answer

SSL Connections from Azure Database for MySQL using CA file

Following along with the Azure Documentation for their New MySQL service, it appears that you can setup SSL pretty simply with their Trusted CA Cert. After following their steps and setting up my PHP connection string according to their docs, I get…
Damien R
  • 41
  • 6
3
votes
1 answer

Error SQL71624: The permission 'CONNECT' is not valid for the target object 'guest' in Microsoft Azure SQL Database v12

I have a SQL database created and I am trying to deploy/move that database to the Azure Cloud by using the Deploy Database to SQL Azure Wizard in SQL Server Management Studio. But I have ran into an error after trying to deploy it. I am using the…
soccerstarz502
  • 33
  • 4
3
votes
1 answer

How to copy a database using Azure ARM API's ?

There is an api to create or update a database. PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2014-04-0 How can I…
Hari Priya Thangavel
  • 487
  • 7
  • 16
3
votes
1 answer

SSL Connection to MySQL Azure failing in Node.js application

Following all of the documentation Microsoft provides for their new Azure MySQL product, I keep getting the same error Error: 140736265921472:error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown…
sjdweb
  • 342
  • 2
  • 10
3
votes
2 answers

How to connect to the Azure database for MySQL and PostgreSQL in JAVA

There're just two new Azure Services released， Azure Database for MySQL and PostgreSQL, As a Java developer I'm wondering how to connect to them, Shall the regular JDBC drivers still work?
Eric_Zhang
  • 85
  • 5
2
votes
1 answer

AKS issues connecting to Azure Database for MySQL Server

This has been previously working but stopped recently. I have a Wordpress container running in an AKS pod that connects to Azure Database for MySQL Server Basic Pricing Tier. Recently the container is unable to connect. I have tried to whitelist all…
RVid
  • 1,207
  • 1
  • 14
  • 31
2
votes
1 answer

Create table in azure database via cli

I know it is possible to create a database server and database in azure by using cli without using azure portal. But is that also possible to create a table in azure database from cmd by using cli? The goal is to script everything.
milan-W
  • 65
  • 1
  • 9
2
votes
1 answer

Create external data source Azure SQL

I was looking for a solution to create an external data source in my SQL Database. CREATE DATABASE SCOPED CREDENTIAL ADLSCredential WITH IDENTITY = '@', SECRET =…
Tristan Le Gall
  • 25
  • 1
  • 7
2
votes
2 answers

How to connect a MySQL database hosted on cloud to Azure Data Factory?

If I have a database that is hosted on cloud, hence publicly accessible, is it possibible to connect to it via Azure Integration-Runtime, or do I have to set up a self-hosted IR? In the official documentation it's not clear, one article indicating…
Jon Popa Freeletics
  • 21
  • 4
2
votes
0 answers

How to use Bitnami Memcached between my Azure WebApp and MySQL DB, both being PaaS service?

I am having an application running under Microsoft Azure WebApp service which is connected to a MySQL Database as a service. Now, I want to use Memcache for my Database, so that database query can speed up, based on excessive application load. For…
GrVardhan
  • 73
  • 6
1
vote
0 answers

Respawn Library Not Clearing Database

I'm setting up integration tests and I'd like to use Jimmy Bogard's respawn library to intelligently clear out any data inserted during tests. My code is running against Azure databases. When I run a test the relevant reset code is being hit (I set…
LkwdDev
  • 23
  • 3
1
2 3 4 5