Azure Database for MySQL is an Enterprise-ready, fully managed MySQL service in Azure.
Questions tagged [azure-mysql-database]
116 questions
1
vote
1 answer
Not able to create stored procedure on Azure Database for MySql
I have configured an Azure Database for MySQL and able to connect to it successfully. I am also able to create New Tables and run queries on those tables but when creating a stored procedure, I am getting below error:-
Er 1227. Access error Code:…
mohit mathur
- 1,094
- 1
- 7
- 10
0
votes
0 answers
Migration of racktables mysql database to Azure Mysql database
i created the dump of the original on-prem database. And am trying to import it into Azure mysql.
the execution of sql statements fails on
/!50003 CREATE/ /!50017 DEFINER=racktablesuser@%/ /*!50003 TRIGGER Link-before-update
It appears i dont have…
anas
- 1
0
votes
0 answers
Migration from Azure MSSQL to Azure MySQL
I am trying to migrate from Azure MS SQL to Azure MySQL. I am using the My SQL Workbench to do the migration but the schema list is empty.
I narrowed it down to the problem being the sys.sp_databases system sp returning no results. I have full…
0
votes
0 answers
Sequelize + Azure Mysql
I`m Trying to connect to Azure Mysql using
const sequelize = new Sequelize(
config.environment.db.db_one.name,
config.environment.db.db_one.user,
config.environment.db.db_one.pass, {
host: config.environment.db.db_one.host,
…
Sergio
- 175
- 5
- 21
0
votes
0 answers
migrating mysql database to azure db
I am tryiing to migrate an existing mysql db to my azure db using migrating wizard, but I get this error during the "bulk data transfer":
Error message:
/Applications/MySQLWorkbench.app/Contents/Frameworks/libmysqlclient.dylib' (no such file),…
Vamonos raza
- 11
0
votes
0 answers
Running into this ERROR when I try to migrate a workbench to an Azure MySQL server
dyld[55763]: Library not loaded: @executable_path/../Frameworks/libmysqlclient.dylib
Referenced from: <75D8AA6C-EE86-3CFC-9881-04C24191CAD3> /Applications/MySQLWorkbench.app/Contents/MacOS/wbcopytables
Reason: tried:…
Vamonos raza
- 11
0
votes
1 answer
Backup status alert for Azure Database for MySQL - Single Server
Microsoft documentation:
Azure Database for MySQL - Single Server takes backups of the data files and the transaction log.These backup files are not user-exposed and cannot be exported. These backups can only be used for restore operations in Azure…
Niahm
- 424
- 5
- 11
0
votes
0 answers
How to assign REPLICATION_SLAVE_ADMIN privelege to a user in azure database for mysql?
I created two azure database for mysql servers to simulate the master-replica architecture.
On replica server, I ran the below command and got the error
Command:-
CHANGE MASTER TO MASTER_HOST='.database.azure.com',…
Vansh
- 43
- 4
0
votes
0 answers
Is possible to send data from Azure Sphere MT3620 directly to a Azure MySQL database?
What I am looking for if there is information anywhere how this can be accomplished. Any documentions or tutorials?
My goal is to send data from Azure Sphere directly to Azure MySQL database.
ken76
- 11
- 2
0
votes
0 answers
ghost docker container mysql self signed certificate in certificate chain
I am trying to get my Ghost Blog (https://ghost.org/) running in a Azure Docker Container.
In the Ghost documentation they describe how to configure the SSL connection for a MySQL database. In Azure I have a flexible MySQL server and I have…
Henkie85
- 197
- 2
- 15
0
votes
1 answer
Azure for MySQL (Single Server): occasional connection timeouts (2003, Can't connect to mysql server on ... (timed out))
My Python (FastAPI) app is deployed to an AKS cluster (several replicas/pods). It makes requests to a MySQL database managed by "Azure for MySQL Single Server". The app works just fine, but I occasionally get timeout errors (more details later). The…
janluke
- 1,567
- 1
- 15
- 19
0
votes
1 answer
Database Connection Problem - Azure MySql Database Server from .net core 3.1
-- Background:
I am using asp.net mvc project with 3.1 .net core.
I have azure setup for hosting it in app service.
For Database, I have mysql database server set up on Azure (version 5.7).
-- Problem:
I am using basic connection string when…
Jems Chaudhary
- 11
- 1
- 3
0
votes
0 answers
can we get Azure mysql flexible server replication lag in seconds metric through API ? I am not sure if Azure provides an API to get that metric data
Is there an API to get mysql flexible server read replication lag in seconds metric data ?. We have an implementation in AWS where we are using the AWS api to get replication lag data to disable/enable mysql replica and we want to do the same in…
Sarmad
- 17
- 5
0
votes
1 answer
Azure mysql single server with private link still resolves to public name
I've setup a MySql single server (we cannot AFAIK use flexible server because we want to configure data encryption which seems problematic on Flexible server).
The MySql single server is setup to disable public access and has been connected to a…
ossentoo
- 1,675
- 2
- 20
- 44
0
votes
0 answers
Unable to stop Azure My SQL instance indefinitely
Through the azure portal I am trying to STOP Azure Database for MySQL single server instance. When I click on Stop button, I get following messgae:
Server will be automatically started after 7 days if you do not perform a manual start operation. The…
SharpCoder
- 18,279
- 43
- 153
- 249