Internal server error while creating azure mysql server
{ "status": "Failed", "error": { "code": "InternalServerError", "message": "An unexpected error occured while processing the request. Tracking ID:…
Possible MySQL database data loss
Hello, We noticed some of our records in the database are missing. We send SMS thourgh our backend and keep the logs in the database. We noticed some people have received our SMS but I don't see any records in the database for them. It is not…
Can Write To Azure SQL Database, Cannot Read
I am so confused on this one. I have been able to write to my Azure Database for MySQL flexible server using python, it works no problem, it uploads my data and I can see the new tables and I can actually read those tables on my wix website no problem. I…
How to get Employees Hierarchy
Hi, My requirement is as follows: I would like to obtain Employee Wise Hierarchy (Bottom Employees to Top Employees) using SP. Note (Role): NH is Level-1(Top Level) VH is Level-2 AVP is Level-3 RM is Level-4 DRM is Level-5 BM is Level-6 TH is Level-7…
Retrieve correct information about publicNetworkAccess for Azure MySQL flexible server
Hi! I'm using the rest api to retrieve information abot Azure Database for MySQL flexible server. In particular, I'm using this endpoint to list all the servers:…
How do I access PHPmyadmin in WordPress as App Service (Linux) with Managed Identities turned on?
Hello Community, We need to access PHPmyadmin to manage our MySQL Database used for WordPress. We are using Standard Hosting Plan of Azure with WordPress on App Service (Linux based) with Managed Identities activated. Now the issue is that we are not…
Azure SQL Server Single instance auto migration authorization not saving (Spinning)
Auto-migration authorization is not saving and just spinning. Cannot save these changes to have microsoft to migrate our SQL database
DB Connection Failed SQLSTATE[HY000] [2002]
Hello All, We have azure web app with Linux OS, php 7.4 stack, publish mode is code and we are using default domain over the same. We are trying to connect the same with MYsql flexible server (Business Critical, E2ads_v5, 2 vCores, 16 GiB RAM, 100 GiB…
Metrics - Resource not found message
When creating a new chart Im getting the following error: Resource not found
Error on sink data to MySQL - communications link failure
I've got a Pipeline with some Data Flow activities that runs in parallel. I've got the error on last night's execution and I'd like some help to understand why and how to prevent it from happenning. Job failed due to reason: at Sink 'EnviaFerias':…
Azure Mysql flexible server - reduce storage size by purging binlog via binlog_expire_seconds
I have set the server parameter binlog_expire_seconds to 30 in Azure mysql flexible server. I was trying to signal the server to purge the binlog in order to reduce the storage size, but the storage size didn't change at all. Any ideas?
SQL OAUTH Connection Setup with Managed Identity using .net Framework Command Line application - Assistance Needed
Hi , We were able to retrieve the access token, but when I attempted to open the SQL connection, I encountered the following error: Microsoft.Data.SqlClient.SqlException: **'Login failed for user '
Linkedserver connection to MySQL database with ODBC driver failed
Hi I am attempting to use a SQL Server 2014 linked server to connect to a MySQL 8 instance. My single openquery insert statement works fine, but when I try to run multiple insert statements to insert data to multiple tables, I receive a generic error…
Cannot change the mysql user privilages
I am using Azure Database for MySQL flexible servers to manage my database. When I run the command below, I receive the result "Access Denied." I don't know how to access the admin account on Azure, but I can access the Azure portal. I have…
Does it possible to move a MySQL database between different Azure Accounts?
Hi all, I have 2 different Azure Accounts. I want to move the mysql database in one of these Azure accounts to my other Azure account. Since the database is approximately 150 GB, I would like to do this with the Azure recommended or best practice method…
How do I create a flexible sql Server in my bash terminal? (Terminal Freezes)
Hello there, I have an issue creating a flexible sql server in my bash Terminal in VS Code. I am doing the Java module "[Deploy a Spring Boot app to Azure App Service]", the first exercise in this module "Create Azure resources and a…
Unable to delete subnet delegate to Microsoft.DBforMySQL/flexibleServers
I have a subnet delegated to Microsoft.DBforMySQL/flexibleServers. I integrate MySql flexible server to that subnet, for test purpose. Now I delete MySQL server and I want to delete subnet as well, but azure does not allow me to do this. Please help me…
Issue: Azure DB MySQL - phpMyAdmin
Hi everyone, I’ve already set up our WordPress from the marketplace, and the plan is Standard general-purpose production apps (P1V2 1 Core, 3.5 GB RAM, 250 GB storage) including phpMyAdmin but when I try to login domain.com/phpmyadmin required…
How can I make a UDL (Universal Data Link) file to test comunication to a data base of Azure database for MySQL flexible server?
How can I make a UDL (Universal Data Link) file to test comunication to a data base of Azure database for MySQL flexible server?
I created an Azure Account, SQL Server and Database as Personal. Need to move to Company tenant
Hello, Years ago I created an Azure account to create a SQL Server and Database for our company, but as I was just learning I made the mistake of making it as a personal account. We have now implemented and integrated more deeply with Microsoft…