Setting binlog_row_metadata to FULL in Azure DB for MySQL

Question

I'm setting up an Azure database for MySQL and attempting to enable CDC but having trouble. To do so using the service that I'd like to use, I need to be able to set binlog_row_metadata to 'FULL', but that doesn't seem available in the UI either on a direct instance or a read replica.

I've tried server parameters in the UI and through direct SQL access but it appears that MSFT limits it. For the latter, I get:

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

Does anyone know if it is possible and if so, how?

Answer 1

Hi anonymous user-6651 Thank you for posting your question on Microsoft Q&A and for using Azure services.

In my understanding, you are trying to set the binlog_row_metadata to "FULL" in Azure DB for MySQL but you are not able to see in the UI portal.

You are right! Some parameters are hidden for Azure MySQL, Microsoft only allows customers to modify only some of the parameters unfortunately.
The error message indicates that normal user doesn't have permission to update this.

Regards,
Oury

Answer 2

thanks, it is helpful though I wish it wasn't the case...