Lesson Learned #73: Azure Database for MySQL – CONVERT_TZ returns null

Hello Team, Today, we have a new service request where our customer asked about the CONVERT_TZ function to convert time to CET, but, unfortunately the function always returns null. Searching in several MySQL webs we found that it is needed to run a process to load the different time zones as are described in these…


Lesson Learned #52: Azure Database for MySQL – Server is not configured to allow ipv6 connections

Hello, Several days ago, I worked in a service request that our customer had configured all elements ( VPN, Site-to-Site, etc…) but they are getting an error: ERROR 9009 (28000): Server is not configured to allow ipv6 connections trying to connect using service endpoint. First of all, I have to mention that currently, Azure Database…


Lesson Learned #31: How to measure a TSQL execution time against Azure Database for MySQL

Often, our customers asked about the connection latency or execution time of a query between their servers and their Azure Database for MySQL. Trying to identify what is the time spent in each step I created this PowerShell Script called SQLMySQLConnectivityTest.ps1 that in based on SHOW PROFILE ALL results shows the time spent in different steps of the query….


GRANT SUPER privilege on Azure Database for MySQL

The SUPER privilege is not supported on Azure Database for MySQL. The closest you can get is to create another admin level user with the same rights as the server admin you created to do this you can run: You can get the privileges the admin account has by logging in as the admin account…


Azure Database for MySQL – Can’t restore database with error “Got error 1 from storage engine”

Microsoft has recently released the preview of Azure Database for MySQL. We noticed that customers who are migrating from other MySQL servers have been facing the error: “Got error 1 from storage engine” While indicated to be a storage capacity issue on a MySQL server when researching this error, in Azure Database for MySQL this…