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

Clicking Register doesn't redirect, and nothing is written to the database. Why?

I set up my own home lab to learn development in the hopes of proving my competence. I am using VSCode to write the code with help from AI. I use Github as my repository: https://github.com/JonathanHoward86/BackendDevProject I use Azure Devops for…
Jonathan Howard
  • 1
  • 4
0
votes
1 answer

Assign the SUM value to the MAX date present for that ID

I have got RequiredQty (A) and ReceivedQty (B) for ID along with dates. I want to sum A and sum B, subtract the difference for each ID and assign this difference to the MAX or LATEST date. SELECT ID, Date, SUM([RequiredQty]), …
cinnamonroll
  • 9
  • 3
0
votes
1 answer

Cannot connect MySql Workbench to an Azure Database for MySql Flexible Server, with private access

I'm trying to connect MySql Workbench to an Azure Database for MySql Flexible Server, with private access, and get this error: "Unable to connect to localhost". Here are the steps I took when creating the various resources on Azure: I created an…
Fabricio Rodriguez
  • 3,769
  • 11
  • 48
  • 101
0
votes
1 answer

I cant connect to MySQL database in Azure using Android Studio(Java)

Im doing a project for school and Im trying to use a MySQL database on azure in android app. The problem is when Im trying to connect to the database using jdbc it say me an error Error: FATAL EXCEPTION: main Process: com.example.trasteros, PID:…
Rydzombi
  • 1
  • 2
0
votes
1 answer

How to connect to Azure Database for MySQL Flexible Server from on-prem system

I have created one Azure Database for MySQL flexible server. I have setup connectivity method as 'Public Access (allowed IP address)'. I have setup firewall rule and added my laptop IP address. I'm trying to connect to this Azure Database for MySQL…
Ajit Medhekar
  • 1,018
  • 1
  • 10
  • 39
0
votes
1 answer

Why is Azure MySQL database unresponsive at first

I have recently setup an 'Azure Database for MySQL flexible server' using the burstable tier. The database is queried by a React frontend via a node.js api; which each run on their own seperate Azure app services. I've noticed that when I come to…
Jess
  • 151
  • 12
0
votes
1 answer

Is it possible to store client data on separate databases?

We have a client who is determined to keep their data in our cloud VM separate from other client data. That is, we have a centralized MySQL database where we store all of our client data and access the data depending on the id etc. The clients are…
user19019404
  • 55
  • 5
0
votes
3 answers

How to connect Azure Database for MySQL flexible server in Azure SQL Server Database

I am trying to set up a connection between Azure MySQL flexible server and Azure SQL database mainly to read data from MySQL and store it in the SQL Server periodically (multiple times a day). I was thinking of creating a stored procedure inside my…
yszilagyi
  • 1
  • 1
0
votes
1 answer

How can I get the connection string to a database hosted Azure in the appsettings.json file?

I have created a database and hosted it in Microsoft Azure. I am struggle to connect to the database because I do not have the connection. Where can I get the connection string? I have tired to find the connection on the Azure platform under the…
TEBOHO MOTLAUTSI
  • 1
  • 1
0
votes
1 answer

Failure to connect an Azure Web App (Go app) to Azure Flexible Database for MySQL

I have a basic Go API I created that works and connects locally. However, when I try to connect it from an Azure Web App I get the error "The specified CGI application encountered an error and the server terminated the process." I am using Gorm …
Welsh
  • 39
  • 1
  • 12
0
votes
0 answers

Automated daily backup option for Azure Database for MySQL Server

Hope you are doing well! I am looking for a third party or azure backup solution for "Azure Database for MySQL Server" where I could schedule daily and monthly backups. I am aware azure is providing backup and restore option but I am looking for an…
Jain
  • 1
  • 1
0
votes
1 answer

How to restore a MySQL database from Azure blob/store to Azure Database for MySQL flexible server

According to this page: https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-migrate-dump-restore You can: Copy the backup files to an Azure blob/store and perform the restore from there, which should be a lot faster than performing…
Andrew Gee
  • 338
  • 1
  • 12
0
votes
1 answer

Error 1064: You have an error in your SQL syntax "VISIBLE"

I am actually just trying & experimenting with MySQL Workbench and Azure Database for the first. So I have modeled a simple model on MySQL Workbench and when I tried to sync with the azure database I got the below error. MySQL Workbench 8.0 Azure…
Unis
  • 365
  • 1
  • 4
  • 13
0
votes
1 answer

Reset password was performed in Azure MySQL, but admin privileges are not restored

I am unable to get the list of all the databases as it looks like my Azure Admin user privileges have been revoked after the admin user password was changed through the admin portal. If I log into the Azure portal then I can see all the databases…
Ilyas
  • 1
  • 1
0
votes
1 answer

Error connecting to Azure MySQL database from Spring Boot

I have been trying to connect to Azure MySQL database from my Spring Boot application. But it gives me the following error com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the…
Remil Michael
  • 41
  • 2
  • 9
1 2
3
4 5