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

Node.js query not inserting data into Azure SQL database

Here is my code for my index.js. Now I made an express server to be able to use /register for my creating an account. All the data that I insert into front end is coming over fine. I'm able to connect and see rows if I use a different code. And it…
0
votes
2 answers

Azure database for MySQL resource is not appearing in resource list in azure portal even when the application using it is working fine

I have a azure database for MySQL, it was created last month. Application using it is working fine but when I logged into Azure Portal to add some firewall rules I can't see the db on the resource list. It appears in billing section to show the cost…
0
votes
1 answer

Is there a way to add client IP in Azure database for mysql using terraform?

I have created Azure database for mysql using terraform and have enabled access to azure services in it using terraform, so is there a way to add client IP also in it through terraform only?
0
votes
1 answer

Azure Database for MYSQL frequently connection failed

I have a Production Database as Azure Database for MYSQL. But its connection failed often. I cant find the issues. Can any one please tell me the reason and how to solve this issues?
0
votes
1 answer

Java program to connect azure database in Netbeans I'm getting error

I'm getting the following error: I tried various ways I'm getting an error please see the following error. run: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at …
ChinnapaReddy
  • 69
  • 1
  • 1
  • 8
0
votes
1 answer

Stored Procedure doesn't create a temp table even after the select * into command is executed

I recently ran into an issue where my SQL Server stored procedure doesn't create a temporary table when specifically asked to do so. However, it doesn't throw an error. It fails when I try to insert data into the temp table. Can you please point…
Hardy
  • 109
  • 1
  • 9
0
votes
1 answer

Null pointer exception error in java button java

Every time I try to enter the details of email password and name it gives null pointer exception on the button. However, everything on the database is also valid, and the connection is established too, but it gives error after I press the add…
0
votes
2 answers

How to perform Archiving and purging in Azure SQL database

I'm using Azure SQL database as my source database.Which include 10 tables. I need to do archiving and purging in the table in a period gap of one year.Currently I am using Azure data factory to move data from source database to data warehouse.Can I…
0
votes
1 answer

How to connect Azure database with Active Directory-Universal with MFA Support .Net Core

I am trying to connect to azure database. My current connection string "return $"Password={this.Password}; Persist Security Info=True;User ID = { this.User }; Initial Catalog = { this.Database }; Data Source = { this.Server }";" like this. How can…
0
votes
1 answer

How do I use Azure Database for MySQL alongside Azure Blob Storage?

I'm trying to find a way to store images and 3d assets as I think they shouldn't be stored in the database (Azure Database for MySQL). I'm thinking that it's better to store them in a cloud storage, so I chose Azure Blob Storage for this reason. I…
0
votes
1 answer

Cannot connect to Azure Database for MySQL

I created an Azure Database for MySQL. When I try connect to it from MySQL Workbench, it cannot connect. However if I test the connection, the test passes. When I test the connection, the test is successful: When I try to connect however, it…
Fabricio Rodriguez
  • 3,769
  • 11
  • 48
  • 101
0
votes
1 answer

Database/schema limit on Azure Database for MySQL?

Is there a limit on the number of databases/schemas I can create on the Azure Database for MySQL platform?
Fabricio Rodriguez
  • 3,769
  • 11
  • 48
  • 101
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…
0
votes
2 answers

Wordpress on azure high CPU

We have a WP with multiple custom modules. It is hosted on the same region on Azure web app and MySQL. From time to time(2-5 times) per month, the database CPU reaches 95% and websites go almost down. There is no any drastic change during these…
johnny
  • 2,032
  • 1
  • 25
  • 45
0
votes
1 answer

Is it possible to set up a mysql environment on Azure that stays within the $50 credit budget for Vs Pro subscription?

TL;DR: Is there a cheap way to set MySql up in Azure, so that i can keep the sandbox environment going monthly within those $50? (App Service + MySql db server) I've been trying to set up a .Net MySql sandbox environment on Azure for the credits…
Djensen
  • 1,337
  • 1
  • 22
  • 32