适用于MariaDB和log_bin_trust_function_creators的Azure数据库 [英] Azure Database for MariaDB and log_bin_trust_function_creators

问题描述

我正尝试在Azure数据库上为MariaDB创建一个函数，如下所示:

    CREATE FUNCTION你好(s CHAR(20))
   返回确定的CHAR(50)
    RETURN CONCAT('Hello，'，s，'！');

但出现以下错误:

   错误SQL(1419):您没有SUPER特权，并且启用了二进制日志记录(您*可能*想使用不太安全的log_bin_trust_function_creators变量)

适用于MySql的Azure数据库也会引发相同的错误，但是在Azure门户上，我们有一个选项变量"log_bin_trust_function_creators"可更改为活动并通过. MariaDB在Azure Portal上没有此变量.

还有其他解决方案可以在Azure数据库中为MariaDB启用功能吗?

还是有其他方法可以更改"log_bin_trust_function_creators" Azure MariaDB的变量?我尝试了"SET GLOBAL log_bin_trust_function_creators:= 1"但提出:

    Erro SQL(1227):访问被拒绝；您需要(至少其中一种)SUPER权限才能进行此操作

I am trying to create a function on Azure Database for MariaDB like below:

    CREATE FUNCTION hello (s CHAR(20))
    RETURNS CHAR(50) DETERMINISTIC
    RETURN CONCAT('Hello, ',s,'!');

but I am getting the error below:

    Error SQL (1419): You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Azure Database for MySql raises the same error, but we have, on Azure Portal, an option variable "log_bin_trust_function_creators" available to change to active and pass it. MariaDB don't have this variable available on Azure Portal.

Is there any other solution to enable function creation in Azure Database for MariaDB?

Or is there other way to change "log_bin_trust_function_creators" variable for Azure MariaDB? I tried "SET GLOBAL log_bin_trust_function_creators:=1" but raised:

    Erro SQL (1227): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

谢谢

推荐答案

The log_bin_trust_function_creators has not yet been exposed on the Azure DB for MariaDB service. We aim to provide the same parameters in both the MySQL and MariaDB services.

由于该功能尚不可用，我们可以考虑通过DevOps更改值.可以请您发送 参数值，服务器名称，订阅ID ，以及 服务器的区域要为此进行调整吗?到Microsoft.com上的AzCommunity.

Since this is not yet available, we can consider changing the value via DevOps. Can you please send the parameter value, server name, subscription ID, and region of the server to tune this for? to AzCommunity at Microsoft.com.

请在以下主题中引用此论坛主题:"Azure Database for MariaDB and log_bin_trust_function_creators".谢谢您的坚持.

这篇关于适用于MariaDB和log_bin_trust_function_creators的Azure数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！