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
0
votes
1 answer

Querying Information_Schema on MySQL (Azure) takes too long

Issue is reading information schema from MySql ... too slow: Steps: 1. MySql dump created manually by scripting all objects from existing MySql db which is on AWS. (MySql Version 5.7) 2. Restored dump file on to Azure MySql (Version 5.7) 3.…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
1 answer

Azure Stream Analytics output to MySQL database

I am new to Azure, but I want to make a setup as the one shown on the picture below: (Device -> IoT Hub -> Stream Analytics -> storage-> application) Setup goal My main problem is the stream analytics output to the database (I have a MySQL database…
Miertz
  • 73
  • 7
0
votes
2 answers

Azure Functions (Python) cannot connect to Azure MySQL instance with [SSL: WRONG_VERSION_NUMBER]

I'm creating a simple Azure Function using Python. It just simply read from an Azure MySQL instance and write something back to the same instance. However, I cannot connect to the database successfully. import logging from datetime import…
Christopher
  • 731
  • 6
  • 24
0
votes
1 answer

Using MySqlDatabase (MySql.Data.MySqlClient) on Azure Functions v2 - "Unable to resolve service"

I have created an Azure Functions app ~v2 project that uses the MySql.Data.MySqlClient dependency. The project is setup to also use the SwashBuckle library to create a callable API. When I execute my project from my local settings, it works fine.…
LatentDenis
  • 2,839
  • 12
  • 48
  • 99
0
votes
2 answers

Spring Boot - Unable to connect Azure MySQL database

I am new in connecting azure MySQL database from Spring boot application. Below is the snippet mentioned in application.properties spring.datasource.url=jdbc:mysql://XXXX.mysql.database.azure.com:3306/MyDbName spring.datasource.username=…
Rakesh L
  • 1,136
  • 4
  • 18
  • 44
0
votes
1 answer

Failed to connect Azure Database using Java(JDBC)

I am trying to connect my Azure Database using JDBC. But it fails to connect. I have used server name,username,database name and password correctly. using Mysql Connector v8.0.13 import java.sql.*; import java.util.Properties; public class…
Lomat Haider
  • 11
  • 3
0
votes
1 answer

Migration task failed at 'load data local infile' while migrating the data from RDS MySQL to Azure Database for MySQL using Attunity Replicate MSM

I try to migrate data from Amazon RDS MySQL to Azure Database for MySQL using 'Attunity Replicate for Microsoft Migrations(Replicate MSM)'. For this I setup the Replicate MSM tool on a Windows 10 machine locally, then I define & test the source &…
Akay Nirala
  • 1,136
  • 7
  • 13
0
votes
1 answer

Azure MySQL Server metrics retrieval from Storage - table or eventhub

I need to fetch "storage_percent", "io_consumption_percent" and "connections_failed" from Microsoft.DBforMySQL/servers in Azure. I could not find any Rest API for same. I tried to export data from Diagnostic Settings to Storage as well as Eventhub.…
ARINDAM BANERJEE
  • 659
  • 1
  • 8
  • 29
0
votes
1 answer

Joomla configuration.php database settings running under Azure and MySql-In App

I'm running Joomla under Azure using the MySQL In-App option for the database. Everything has gone well, but I have been unable to get the database config variables in JConfig to pull dynamically from the MYSQLCONNSTR_localdb environment variable.…
bjm
  • 33
  • 1
  • 5
0
votes
0 answers

How to link a Web App to a MySQL Azure database?

EDIT : I changed the port used, before 8081, but still have a problem with the error 405 with my index.js. Organization looks like ├── ... ├── site │ ├── server │   │   ├── index.js │   │   ├── ... │   ├── wwwroot │   │   ├── index.html │   │  …
Nemzytch
  • 171
  • 1
  • 1
  • 7
0
votes
2 answers

connection String is not right. Please visit portal for references

I am not able to login into my application on azure environment.I have added driver class, username and password in my application properties file. I am using my sql workbench but everytime I login its showing me the error that connection string is…
shagun dhiman
  • 7
  • 6
0
votes
1 answer

Azure database for MySQL DB 5.7 Transient handling in .net core

I am creating .net core 2.1 MVC application and using Azure database for MySQL DB 5.7. I have read below links but seems they are applicable for MS SQL…
knowdotnet
  • 839
  • 1
  • 15
  • 29
0
votes
1 answer

Mysql month number to month name conversion

I have month value like "22018" in my column I need it like Feb-2018 in mysql workbench
Shivashant
  • 15
  • 5
0
votes
4 answers

enable binary logging Azure mysql server

I have created one Azure MYSQL server (DaaS/PaaS). Now I have to enable binary logging. I have checked the Azure MYSQL server parameter & I couldn't find this specific setting.May I know, How can I enable this log ? Currently Log_bin = OFF.
Inzi
  • 348
  • 3
  • 12
0
votes
0 answers

Operating systems for some azure services

I was looking at Azure documentation but I couldn't find what type of operating system does Azure for MySQL and Azure Redis Cache use. I assume that for redis it should be a must to use Ubuntu but can't find any details about underlying…
M.R.M
  • 540
  • 1
  • 13
  • 30
1 2 3 4 5 6
7
8