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

Can 'Temporary Symmetric Keys' be dropped in the same session which created it in Azure SQL?

Even after closing a connection temporary symmetric keys were not deleted from tempdb.sys.symmetrickeys. I want to understand if I can always drop them in the same session without worrying about permissions ?
Arpit A.
  • 109
  • 1
  • 6
0
votes
1 answer

Added extra columns in the database, but the code doesn't see them

I'm getting a headache from this...hope someone can help me. I have a Table Clienten and made 3 new colums: DhrMevr Voornaam Achternaam I refreshed the database, deleted the old DataSet and created a new DataSet for the updated…
Mirelle
  • 11
  • 3
0
votes
1 answer

Azure "MySQL in App" An attempt was made to access a socket in a way forbidden by its access permissions

I activated “MySQL in app” on Azure and clicked the “Manage” link. A phpMyAdmin login page launches. Login does not accept any username/password combo including what I find in MYSQLCONNECTSTR_localdb.ini. Is there any other setup required to access…
codezoo
  • 593
  • 1
  • 6
  • 16
0
votes
2 answers

How to Connect into a MySQL in azure server using SQLAlchemy

I need some help. I created a CRUD with Flask, and I want to conect it with my MySQL in azure. I new using Flask, so I don't know how to do it. Somebody can help me? Now, I tried to do…
rodrigo lima
  • 1
0
votes
1 answer

can we setup a sync of databases between on-premises MySQL server to Azure Database for MySQL

by using mysqldump I am able to migrate data from on-premises to Azure Database for MySQL. but now after dump and restore i want to create a continuous sync between them. how's it possible? I have followed below link but havn't achieved it. Is it…
shubhi jain
  • 29
  • 3
0
votes
1 answer

Azure mysql connection redirection changes encoding

I use a php app that connects to mysql in Azure. I use utf8mb4 as encoding and utf8mb4_unicode_ci as collation. Everything works as usual when I connect to Mysql without connection forwarding. When I enable connection forwarding in the php.ini as…
stena
  • 667
  • 5
  • 19
0
votes
1 answer

Azure: An attempt was made to access a socket in a way forbidden by its access permissions 10.0.0.4:3306

I created a mysql database instance in North Europe, then a Web app there in North Europe, via VS published in Azure and at startup I get an exception as in the screenshot. Everything works locally in VS using this connection string, but not in…
Alex T.
  • 1
0
votes
1 answer

import mysql database from local to remote server

i would like to import a dumped local database into a remote "azure database for mysql server" using cronjob. in terminal it works fine with this command: mysql -u[USER] -p[PASSWORD] -h[REMOTE-HOST] --ssl-mode=REQUIRED…
emil
  • 31
  • 1
  • 7
0
votes
1 answer

MySQL Query always returns only '1' in azure app service + azure database server

Currently, I am coding using azure app service and azure database server for mysql. When the 'select' statement is executed, only '1' is returned. I don't think it's a connection problem because 'insert' statement works fine. This is my php code…
최정태
  • 13
  • 2
0
votes
0 answers

azure mysql database replication with on-prem mysql master is failing with 2003 error

I have setup azure mysql master database and I would like to do data-in replication with an on-prem mysql database but the replication is failing. Can someone tell me the reason ? I am able to connect azure mysql to on-prem mysql master running the…
user2511126
  • 620
  • 1
  • 14
  • 31
0
votes
1 answer

Azure Wordpress charging after being deleted

I deployed my WordPress website on the azure web-app. MYSQL Server for WordPress started charging a crazy amount of money. I stopped MySQL server initially but it didn't help. Then I deleted the resource group altogether, but MySQL server instance…
ahmadabdullah247
  • 341
  • 1
  • 4
  • 16
0
votes
0 answers

Azure mysql DB with entity frameworkcore error

i just finished building my application and came to find out that the azure mysql db i created is giving me some errors. When i use a normal mysql db locally during development everything works fine and perfectly, when i seeded some data into the…
user13468285
0
votes
1 answer

Is there anyway to Automate Azure MySql Import/Export

I am trying to Automate Import/Export process of Azure MySQL DB. Unlike Azure SQL DB I don't find the Azure PowerShell command or through Azure portal to perform Import/Export of Database. I want to have a script which can automate import/Export…
Nitesh Singh
  • 338
  • 3
  • 10
0
votes
1 answer

Can't migrate ~50Mb MYSQL database to Azure App Service + MySQL in app

Hi I am having an issue importing my database to the Azure App Service MySQL in app. My database is around 50Mb, and when I try to import the database I see that it fails to import. I suspect that this is due to a limit on maximum size allowed for…
cobethur
  • 290
  • 2
  • 8
0
votes
2 answers

Executing MySQL procedure from Azure Data Factory

I wanted to 'Call' MySql (Azure) Procedure from Azure Data Factory. I can with SQL Server Procedure from ADF but not MySQL Procedures. How can this be achieved, are there any other service which can be integrated with ADF to call this mysql…
Sreedhar
  • 29,307
  • 34
  • 118
  • 188
1 2 3 4
5
6 7 8