none
Azure Database for MariaDB and log_bin_trust_function_creators RRS feed

  • Question

  • 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

    Thanks,

    Tuesday, January 22, 2019 6:13 PM

All replies

  • 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.

    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.

    Please reference this forum thread in the subject: “Azure Database for MariaDB and log_bin_trust_function_creators”. Thank you for your persistence.

    Thursday, January 24, 2019 6:29 AM
    Moderator