Re: [Maria-discuss] How to give user permission to create a trigger?

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

rr

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net 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 |