Can't Create Trigger with binlog Replication

MySQL & MariaDB Other MySQL® Questions
1

Hello everyone,

I’ve gone through the MySQL documentation, but apparently i am not smart enough.
Our environment is based on a MySQL Binlog replication with Oracle MySQL 8.0.40. When trying to create a trigger, I consistently receive the “ERROR 1419” error.
image

The test user has been granted all privileges on the test database.
As a quick fix, we’ve enabled the “log_bin_trust_function_creators” option, but due to its deprecation, we’re seeking a future-proof solution. Since SUPER privileges are also deprecated, they’re not an option either.

I’d be very grateful for any suggestions.
Thank you in advance, and have a great day! :slight_smile:

2

In that scenario, the function or trigger must be declared/created with the DETERMINISTIC characteristic

A setting of 0 also enforces the restriction that a function must be declared with the DETERMINISTIC characteristic, or with the READS SQL DATA or NO SQL characteristic.