maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #05717
Re: How to give user permission to create a trigger?
-
To:
Reinis Rozitis <r@xxxxxxx>, maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Thomas Plant <thomas@plant.systems>
-
Date:
Mon, 24 Feb 2020 14:06:45 +0100
-
Arc-authentication-results:
i=1; ORIGINATING; auth=pass smtp.auth=thomas@plant.systems smtp.mailfrom=thomas@plant.systems
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=plant.systems; s=2018-10; t=1582549606; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=IvcQrPf6j4wWkWkXEagtZb5nT2zbKTaU+4LsHRwJ00I=; b=NllrII2HiUiIl/62/V8ZFD/h/oqNpp5qSERCXg6u5CVnsuoxC3TdPGmCvamvE57TtFXPWL ABvE0vfMON4S6xJZDNEg47pqum2RHEXrQspUQNXrX34HF/JzGGL63sfuN65U39l5cDhOHx V/+2NLJGwysqPCdsfJVT4m/BR05c1soSP5MnibmdQrKySbZLVlds2x7VFXNIRJ7aIabgq8 nNlEhIU4VEHPw+nHP5yNlh8hQB9E2eIozfo0k/buHI4iZs0CsTeIQSXFolt1B2p3nXDj+V 7h8++d1AkrxEeIe8cOmfGZgk68zQ+8ylDMbAsOKlvchiRkhVtxXDz9nMRdirLA==
-
Arc-seal:
i=1; s=2018-10; d=plant.systems; t=1582549606; a=rsa-sha256; cv=none; b=EODWIFZhnH6zywjMy/N/+TdHMB+dDKZZfCBtmWPt+zK1Z53HOJnu9bpX5VIJHIJOTu7yDY jcgvyJ68w9ZQAKAZ2a4fZfLotch3DwqiT/SlHce4VpXbUouXphfV++Zf6k8Iy19E9V1Ypp LkAr2qH9g+TCabXrYWzidkXJuaW23DmHWkKKdqvjvj5Wy2fDkfuznK6G7L9FNmImHaRN0F HdfWkY2g9HHvEY8lGqg4OW7tOI/vE4tUGuq49RsGL7JNMdFvwjwo1Cw75y2VGXQVhH1mCI yVfWtxGn5I2cloDPVLCBeco6OPO3kYiqvNMB4YafBOarjgRhqt6Tmi9BHLRP/Q==
-
Authentication-results:
ORIGINATING; auth=pass smtp.auth=thomas@plant.systems smtp.mailfrom=thomas@plant.systems
-
In-reply-to:
<000401d5eb10$ba3ece60$2ebc6b20$@roze.lv>
-
User-agent:
Mozilla/5.0 (Windows NT 10.0; WOW64; rv:68.0) Gecko/20100101 Thunderbird/68.5.0
Am 24.02.2020 um 13:48 schrieb Reinis Rozitis:
>> Is there a way to resolve this?
> You should probably set the log_bin_trust_function_creators to ON. Then SUPER privilege is not required.
>
> https://mariadb.com/kb/en/replication-and-binary-log-system-variables/#log_bin_trust_function_creators
>
> rr
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help : https://help.launchpad.net/ListHelp
Thanks for the answer,
we are using 'mixed logging' in the binary log so should be safe
activating '|log_bin_trust_function_creators = ON'?
Do I have to set it on the master only or slave to?
Thomas
|
Follow ups
References
