Questions tagged [azure-mysql-database]

Azure Database for MySQL is an Enterprise-ready, fully managed MySQL service in Azure.

116 questions
0
votes
2 answers

Lost server admin user access for azure database for MySql server

We have recently migrated database of our core angular application to use Azure database for MySQL and got server admin user created for us. Recently, by mistake, we incorrectly removed privileges for server admin account and lost all access on our…
0
votes
1 answer

How can I get an updated server parameter to take effect in Azure Database for MySQL?

In the Azure portal I set the value of server parameter lower_case_table_names to 2 and successfully saved, but when I login to the server the change is not reflected: mysql> SHOW VARIABLES LIKE 'lower%'; +------------------------+-------+ |…
Mischa
  • 42,876
  • 8
  • 99
  • 111
0
votes
1 answer

How to create mysql server on azure using python script

I have to create mysql server on azure using python script Is there any way to create it?
sumit salunke
  • 125
  • 2
  • 10
0
votes
0 answers

Azure Managed MySQL

I am not able to find a way to create read-only replicas for MySQL in Azure Managed MySQL. Neither I can enable the binary logging in existing production instance. Is that a feauture Azure Managed MySQL does not provide?
0
votes
1 answer

Questions about mysqldump and Microsoft Azure

I need to dump database which hosts on Microsoft Azure. I tried following: 1. Connect to db with MySQL Workbench. 2. Select Data Export and use it. The warning message says that 'unequal version of mysqldump(8.0.12) and MySQL Server to be…
0
votes
1 answer

Azure Mysql Database service generate failed connections when too many connections needed

We have a problem when applying stress test (sending too many users in the same time) to our application, our application trying to create new connections to serve users, but azure Mysql DB service is generating a lot of failed connections. even…
J Doe
  • 3
  • 1
  • 3
0
votes
3 answers

Connect Spotfire Azure MySQL database

How do I connect Spotfire to my Azure MySQL database? I get an error when I try to connect to the normal Microsoft Azure. I'm running Spotfire version 7.7
Will
  • 605
  • 2
  • 11
  • 23
0
votes
2 answers

How to connect to Azure Ubuntu VM MySQL server from local machine MySQL workbench?

I did set INBOUND PORT RULES in Azure. but still it is not working. I want to connect this with MySQL workbench and with google VMs it works. If you can please help with this?
-1
votes
1 answer

mysql/mariadb: why the connection is not established when i replace DNS with its corresponding IP?

i have deployed mariadb on Azure with ssl enabled. The server name looks like : somename.mariadb.database.azure.com i installed mariadb client on my jumpserver. I did nslookup somename.mariadb.database.azure.com and which gives 10.0.4.68. However…
Mohamed
  • 239
  • 1
  • 4
  • 17
-3
votes
1 answer

MySQL server on Azure portal db cannot use default (current_date)

When running creation_date date default (current_date), getting error on MySQL server on Azure portal, but not on local MySQL workbench. How can we give the current date as default?
ILovePizza
  • 141
  • 1
  • 8
1 2 3 4 5 6 7
8