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

How to migrate Azure MySql database to Azure MS SQL Database

It's clear on how to migrate on-premise or RDS MySql database to Azure MS Sql, using Data Migration Assistant for MySql or the azure Database Migration Service, but absolutely nothing for Azure MySql to Azure Sql. What is the best way to migrate…
Ian
  • 2,898
  • 1
  • 27
  • 29
0
votes
1 answer

Azure MySQL: SSL Connection Error: Unable to get certificate

I have been trying to connect to Azure MySQL database via MySQL Workbench v8 by following this document. Although I am able to connect to the MySQL server via command line, the same connection via MySQL Workbench does not succeed. It throws an…
Ranbir Sinha
  • 91
  • 2
  • 9
0
votes
1 answer

Connection between frontend, middletier and database using AAD tokens in Azure

I am trying a setup of two app services (frontend and middletier) and a mysql database in Azure. I would like to setup the following scenario: User authenticates to the frontend app using Azure AD. The frontend app fires a REST call to the…
Ranbir Sinha
  • 91
  • 2
  • 9
0
votes
1 answer

Create a private endpoint for a specific MySQL server in Azure

I have an existing MySQL server created on Azure cloud. Now I want to establish a private endpoint connection using Java code (SDK). Can you please help me which Java class to use to achieve this problems. Azure cloud screenshot
Achintya
  • 77
  • 8
0
votes
0 answers

table using json fields in mysql 8 take up unusually more space than actual data

CREATE TABLE `user_info` ( `id` INT(10) NOT NULL, `doc` JSON NOT NULL, `rev` INT(11) NOT NULL DEFAULT '0', `created_at` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` DATETIME(3) NOT NULL DEFAULT…
UNHO
  • 1
  • 1
0
votes
1 answer

How to use init_connect in azure database server for mysql

Have created a mysql server which has somehow log_bin set to ON and enforce_gtid_consistency is also set to ON. Now this is causing few issues in my case and i want to turn OFF those variables. Process i have tried 1. Create a .my.cnf file in user…
Kingshuk Deb
  • 1,700
  • 2
  • 26
  • 40
0
votes
1 answer

Linking MySql Database to Azure

I have a Database using MySql, however i want to migrate to azure MySql which i know is possible, I am new to Azure. My question if i make changes to the local database, is it possible to automatically update the tables in azure with same changes? I…
Chizom Wornu
  • 15
  • 5
0
votes
0 answers

Azure Server name not found

I followed the tutorial as mentioned on the website "Create Azure database" https://learn.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-portal Still while trying to connect to the database from local cmd it…
Kushal D
  • 1
  • 2
0
votes
2 answers

Creating Azure My SQL - unable to create an available server name

I am trying to create a MySQL Server in the Azure Free Trial but it doesn't matter how random or specific I enter the Server Name under the Server Details, it is returning an error stating that the "Server name must be available" Create MySQL…
Tim Ridolfi
  • 1
0
votes
2 answers

Mysql.Data and Azure Mysql error 'Table 'mysql.proc' doesn't exist'

When I try to execute the stored procedure against Azure MySQL version 8.0.15 server using following code I get the error saying 'Table 'mysql.proc' doesn't exist'. This error does not happen with older versions. some search says to use…
sammym
  • 105
  • 1
  • 9
0
votes
1 answer

Using Roles in MySQL Azure - Privileges Issues on Admin Account

Provisioned MySQL Sever on Azure. While provisioning created Server Admin Login Ex: mySqlAdmin Now we are trying to start creating Roles and assigning Users to Roles. Logged into SQL Work Bench with Admin Account ( mySqlAdmin ), which was created…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
1 answer

MySql Admin User lost Privileges

On PreProd - MySqlServer Admin account lost the privileges which was all good yesterday. When ran show grants for xxxxxadmin;on Dev its resulted as On Pre-Prod (which was same as Dev) There is no other admin account to log into the server. Is…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
2 answers

Azure MySQL Azure Active Directory Access Token

I got MySql Server on Azure and is configured with Azure Directory Admin. Example MySql Servername: mysqlserver and MySql AD Admin Account: admin@organistionname.com.au (this organisation domain account) Can see above account from MySql Server…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
0 answers

Connecting myPHPAdmin (Azure) to MySqlb (Azure) through SSL

I got MySQL 8 on Azure with 'Enfore SSL Connection' Enabled Configured connection string to above in MySQL in App with connection string (Web App) provided by above MySQL Which is Database={your_database}; Data…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
0
votes
1 answer

Azure Function using MySQL In App cannot connect using EF

I have an Azure Function app. I have enabled MySQLin App feature. My function is written in C# using EF Core. When attempting to establish a connection using MYSQLCONNSTR_localdb as documented, I get an exception in the logs. This is my code to…
jlo-gmail
  • 4,453
  • 3
  • 37
  • 64
1 2 3 4 5
6
7 8